View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Can you choose direction on the radar chart?

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!