Thread: polar plot
View Single Post
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

In article ,
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