Colors/Scale in Radar Charts

G

Guest

Is there a way to make the background colors in a radar chart different than
white? I need to create a radar chart with four ranges from center out -
dark green in center, next region out is light green, next region is yellow,
and the outer band is red.

Also, can I make the scale not be equal (e.g. 0-33%, 33-66%, 66%-90%,
90%-100%)?

Thanks for any help.

Jeff
 
A

Andy Pope

Hi,

You can use 4 additional series charted as filled radar to give the zone
shading.
Start by creating a radar using all 5 columns of data. Select the actual
data series and move to the secondary axis.
You can now change the chart type of the other 4 series to filled radar.
Format each series to the correct color.


Data Green light green yellow red
a 26.15% 100.00% 90.00% 66.00% 33.00%
b 73.00% 100.00% 90.00% 66.00% 33.00%
c 54.44% 100.00% 90.00% 66.00% 33.00%
d 5.40% 100.00% 90.00% 66.00% 33.00%
e 87.50% 100.00% 90.00% 66.00% 33.00%

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Radar Charts and fill colors 1
Small Multiples with Common Scale 2
Conditional colors for bars in a chart??? 7
Consistent colours between worksheet charts? 3
Colour gradients in charts 2
Specific colors in a pie chart 3
Chart dependent on column 1
separate colors for positive and negative bars in bar charts? 1

Top