Excel 2003 charting circular or spherical coordinates
 

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

I have Excel 2003.

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/
_______


Scott @ Nordion wrote:

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

I have Excel 2003.

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

"Jon Peltier" wrote:

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/
_______


Scott @ Nordion wrote:

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

I have Excel 2003.