polar plot

A

ApeMan

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)?
Click to expand...
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

Similar Threads

FAO Andy Pope please... 4
can i draw a polar graph with microsoft office exel? 1
Can Excel plot data in a polar chart? 1
Looking to flip text in Excel file (2010) 0
How do I change x-axis in an Excel Radar Chart? 1
Plotting Graph with dynamic table 3
X-Axis Appearing in Plot Area 2
Plotting x-y data to same physical dimension on plot 2

Top