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! |
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! |
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! |
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! |
All times are GMT +1. The time now is 11:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com