Spider/Radar Chart

[Guest]

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

 

[Andy Pope]

Hi,

I think you would need VBA to do this. You could use additional data series
it depends on how much size and colour variation.

If you create a normal radar chart and then record a macro of you formatting
an individual data point, changing it's colour and marker size, you will
have the starting point of the code.

Cheers
Andy