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!

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" <AnnaS@discussions.microsoft.com> wrote in message
news:397E157E-29DC-47E2-90A1-BBB48171E038@microsoft.com...
> 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!
>

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" <AnnaS@discussions.microsoft.com> wrote in message
> news:397E157E-29DC-47E2-90A1-BBB48171E038@microsoft.com...
> > 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!
> >
>

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
_______



"Anna S" <AnnaS@discussions.microsoft.com> wrote in message
news:3ED82DE8-B266-49D6-85C9-502DC3071B70@microsoft.com...
> 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" <AnnaS@discussions.microsoft.com> wrote in message
>> news:397E157E-29DC-47E2-90A1-BBB48171E038@microsoft.com...
>> > 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!
>> >
>>