View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Wes12
 
Posts: n/a
Default Plot R-Theta [angle (0~360 degrees) and amplitude] chart in Ex

Thanks, Good suggestion.

"Tushar Mehta" wrote:

In article , Wes12
@discussions.microsoft.com says...
How do you plot an R-Theta chart in Excel, i.e. a circular chart with the
independent axis (angle) in degrees from 0 to 360 degrees and amplitude as
the radial distance from the center point?

You have to convert the data to (x,y) with the formulas x=r*cost(theta) and
y=r*sin(theta) where theta is in radians.

--
Regards,

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