Radar Charting problems, Can I change...

[Stella]

Hi people

I have 2 queries relating to Radar charts in Excel (Office XP/2002).

Can I change the angle/start position of the first plotted point? I
always starts at 12 o'clock but I want it to start at 9 o'clock. I ca
re-order the data to achieve this effect but the data, to the viewer
is not in a logical sequence if I do that.

Then also, can I change the direction of the plotting from clockwise t
anti-clockwise?

Thanks in advance.

Stell

 

[Jon Peltier]

Stella -

You can't do these things (unless someone smarter than me knows how),
but you could set up a display range in the sheet, so the user sees data
in the way that makes sense, while the chart source data is hidden out
of sight. Either data set could be linked to the other, depending on
whether the user would be allowed to change the values.

- Jon

 

[Stella]

OK

Thanks for the information.

To get around this I have done pretty much what you suggested,
created a second worksheet that collects the data from the firs
worksheet, reorganises it then the chart is plotted from the 2n
sheet.

Thanks again.

Stell