Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you choose direction on the radar chart?
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you choose direction on the radar chart?
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can you choose direction on the radar chart?
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! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
24 hour radar chart by day | Charts and Charting in Excel | |||
Spider/Radar Chart | Charts and Charting in Excel | |||
Radar Chart | Charts and Charting in Excel | |||
radar chart | Charts and Charting in Excel | |||
about radar chart | Charts and Charting in Excel |