polar plot

G

Guest

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

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top