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
he
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
_______
"Anna S" wrote in message
...
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?
--
Anna
"Shane Devenshire" wrote:
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" wrote in message
...
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!