Color Radar Charts

[rdirvngjr]

Greetings...
Want to know if it's possible (and if yes how) to color the areas between the axis of a radar chart with different colors. For example, you have a 4 ring radar chart. you want the center ring to be red, next ring yellow, the next light green and the last (ring farthest from the center) green.
Thanks....

 

[GlennUK]

Can you describe what your chart looks like? It doesn't sound like a radar chart to me.

 

[rdirvngjr]

Sorry, but I've tried to paste an image of the chart, but it doesn't show up. It is definitely a radar grap, but instead of the rings that the join the data points on each axis being 'clear', they are filled in with different colors. If data points are in the 'outer ring', no matter what axis, they're good; in they fall in the inner ring, the red ring, they're not.

And I'm not talking about a 'filled' radar chart that simply fills in the area of the between the linked data points, but coloring the rings that make up the spider web.

Hope this helps
Dean

P.S. If you know how to paste in an image, please let me know. And thanks for answering.

 

[GlennUK]

Is this thread any use? Look at the suggestion by Andy Pope :

http://www.excelforum.com/excel-charting/706543-archery-target-chart.html

... on the other hand you might not be able to download that ... I just tried and failed.

 

[GlennUK]

OK, if you register you can download his example.

 

[rdirvngjr]

Thanks Glen. Was able to download example and this gave me some ideas. Also, since i had to register, went ahead and posted my question on the other board.

 

[rdirvngjr]

Glen...can't see how/where they colored in the rings on the 'target'. Can u help?

 

[GlennUK]

The rings are series in the radar chart. You colour them the usual way that you colour series.

 

[rdirvngjr]

Hey Glen...
I've been able to get the color in the rings (see image); however, I can't get the "data" values to display as a normal radar plot line unless I highlight in the range (sorry, but don't have web site so can't past image or example) or select the data value column and change chart type. But the later option adds and axis to the chart. I'm close, but still not there, so any help will be appreciated. Thanks....
Dean

If I select the

 

[GlennUK]

In that example the data values aren't a radar plot, they are points in an X-Y scatter ... is that going to be good enough for you?