polar plot

[ApeMan]

How do I plot a series of data as a polar graph (ie. with circular axes that
go from 0-180 degrees)?

[Tushar Mehta]

In article <735C3694-F20F-48AC-A3C7-EA06046EB5FD@microsoft.com>,
ApeMan@discussions.microsoft.com says...
> How do I plot a series of data as a polar graph (ie. with circular axes that
> go from 0-180 degrees)?
>
Create a XY Scatter chart recognizing that R,theta and X,Y are related
through:

X=R*cos(theta) Y=R*sin(theta)

theta is expressed in radians, if you have angles in degrees, convert
to radians through RADIANS(theta-in-degrees) or with the equation
theta-in-radians = theta-in-degrees / 180 * PI()

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

[Bernard Liengme]

see my webpage www.stfx.ca/people/bliengme/ExcelTips
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ApeMan" <ApeMan@discussions.microsoft.com> wrote in message
news:735C3694-F20F-48AC-A3C7-EA06046EB5FD@microsoft.com...
> How do I plot a series of data as a polar graph (ie. with circular axes
> that
> go from 0-180 degrees)?