View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Risky Dave Risky Dave is offline
external usenet poster
 
Posts: 161
Default Spider/Radar Chart

Hi,

Is it posible (given access to the appropriate data sources of course) to
create a radar chart with the following attributes:

1) Each radial line from the centre represents one data set (in my case,
groups or catregories of events)
2) The distance from the centre along the radial represents another data set
(proximity, or time to an event)
3) The size of the plotted points varies to show the severity of the event
(this is the one I'm struggling with)
4) The colour of the data point varies according to how much control I have
over the event

Effectively, what I'm trying to do is combine some of the properties of a
bubble chart (size and colour of of data points) with a radar.

this is in excel 2003, if that makes any difference.

TIA

Dave