Excel 2003 charting circular or spherical coordinates

[Guest]

Long time user of Excel, long time issue:
Is there a way to plot (chart) using circular or spherical coordinates?

I have Excel 2003.

 

[Jon Peltier]

Scott -

Go to the charting section of Stephen Bullen's web site:

http://oaltd.co.uk/Excel/SBXLPage.asp#Charting

and look for FunChrt6.zip, which shows how to use polar coordinates.

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

 

[Guest]

Thanks for the link - the sample spreadsheet has some nice features.
One way or another you still have to feed Excel X and Y coordinates. (I've
always created extra columns for X and Y: the "brute force" method.)
I think it would be a nice improvement to Excel if you could plot polar
coordinates without an added conversion step.
Scott