On Sunday, May 25, 2003 at 11:53:12 AM UTC+5, TB wrote:

Thanks for the input.
I ended up doing exactly that - setting the axes test at 45 deg to the axes using Excel, then copying the whole mess into Word, where I broke it into a picture and rotated the axes and data, while leaving the labels intact.
Bit of a cludge fix, but it worked for the purposes I needed it for.
Probably never use another radar plot in my life!

"Andy Pope" <an...@andypope.info> wrote in message news:%23CYA$7qHDH...@TK2MSFTNGP11.phx.gbl...

Hi TB,

You can not change the angle of the axis.

Some work arounds could be.

Save the chart as a picture and the rotate the picture in an external
app. You would have to angle the labels before rotating the picture.
The chart would no longer be dymanic.

Create the radar chart using a xyscatter and some formula. Not easy.
Not suitable if the radar chart uses filled plots.

You could experiment.
Try plotting 8 data points on your radar chart.
Now replace some values with =NA(). This works well except for the last data point. But you may be able to use a approximate value to give you
the chart you need.

If you want to email me, off group, an example of your chart I will have
a play.

TB wrote:

I actually found a use for the Radar Charts in Excel! It seems to be

what I

am looking for, but to really complete it, I need to be able to rotate

the

graph so that the axes are at 45 deg to the page (i.e. the set of axes

looks

like an X on the page, rather than +.

Any thoughts would be appreciated

--

Cheers
Andy

http://www.andypope.info

Hello,
I would love to share with you how to visualize your data in Google Sheets and Excel.

I used ChartExpo™ to make charts in just few clicks.

ChartExpo™ is both an Excel and Google Sheets data visualization tool.

What makes it so easy is that since it works perfectly with both spreadsheets, you can use it with your favorite spreadsheet.

You can easily use ChartExpo™ without any knowledge of coding or programming.

ChartExpo™ has over 80 visualizations in its library.

Installation Sources:

Google Sheets: https://chartexpo.com/utmAction/MTErY29tbXVuaXR5K2dzK1NCK0dHKw==

MS Excel & 365: https://chartexpo.com/utmAction/MTErY29tbXVuaXR5K3hsK1NCK0dHKw==

Regards.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)