Can you choose direction on the radar chart?

[Anna S]

Hi!

I've a question about the radar chart. Is there any way that you can choose
if the chart should be plotted clockwise or anti-clockwise?

Thanks!

 

[Shane Devenshire]

Hi Anna,

Reverse the order of the numerical values so if you were plotting

A 1
B 2
C 3

instead plot

A 3
B 2
C 1

Cheers,
Shane

 

[Anna S]

But is there any way to make it so that you won't need to change the order of
numbers? Can you use a formula or a macro?

 

[Jon Peltier]

Radar chart axes don't have a "Plot Categories in Reverse Order" setting.
You could put a checkbox on the sheet. Write a formula that either returns
the ith or the (n-i)th value in the list, depending on whether the checkbox
is checked. Rather than describe the process, I've posted a simple example
here:

http://peltiertech.com/Sample/RadarReverse.xls

I didn't reverse the first item in the list, so that it is on top of the
chart whether drawn clockwise or counterclockwise.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______