I think copying the chart as a picture and pasting it, followed by rotation
by 45 degrees is the way to go. Eight values (8 spokes) will result in an
octagonal radar chart, with 8 spokes instead of 4. If spokes 1 and 3 have
equal values of a, spoke 2 needs a value of a/sqrt(2) so the three are
collinear, and the relationship for spoke 2's value is more complex if
spokes 1 and 3 have different values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Sun, 16 Mar 2008, in microsoft.public.excel.charting,
"Becs \"I Know Nathing\"" said:
I need to rotate (the whole of my) my square-shaped 'radar' chart
45degrees
so that it is diamond-shaped. At the moment the lines of the axes are
horizontal and vertical and make a cross-shape (not unlike a + shape) and
I
need the lines to be on the diagonal (making a X shape).

The chart doesn't have a green dot which I could use to rotate the whole
chart.

Annoying, isn't it? We've discussed this recently, and I mentioned that
Radar chart should have a control similar to the one provided for Pie
charts, but it doesn't.

I think you're just going to have to turn your table into eight values
instead of four, with the extra four values being an interpolation of the
four original values. So it becomes an "octagonal" radar chart, but the
octagon nature of it is hidden because you're carefully calculating the
intermediate values so that they lie on a straight line. I think AVERAGE()
should work okay.

Or, you could use a graphics program to rotate the picture through 22.5°

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.