Posted to microsoft.public.excel.charting
|
|
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
|