View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Colors/Scale in Radar Charts

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jeff Gross" wrote in message
...
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