Thread: 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.
>