software

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?

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

Thanks, Good suggestion.

quot;Tushar Mehtaquot; wrote:

gt; In article gt;, Wes12
gt; @discussions.microsoft.com says...
gt; gt; How do you plot an R-Theta chart in Excel, i.e. a circular chart with the
gt; gt; independent axis (angle) in degrees from 0 to 360 degrees and amplitude as
gt; gt; the radial distance from the center point?
gt; gt;
gt; You have to convert the data to (x,y) with the formulas x=r*cost(theta) and
gt; y=r*sin(theta) where theta is in radians.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;

Hi,

These maybe of interest to you.
www.andypope.info/charts/polarplot2.htm
www.andypope.info/charts/polarplot.htm

Cheers
Andy

Wes12 wrote:
gt; How do you plot an R-Theta chart in Excel, i.e. a circular chart with the
gt; independent axis (angle) in degrees from 0 to 360 degrees and amplitude as
gt; the radial distance from the center point?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Hi Andy,

I've shied away from using a Radar plot for parametric plots because I've
always seen it as more like a Line chart turned into a circle rather than a
XY Scatter chart.

But, as you demonstrate, it does have some advantages. There's no need to
specify theta values (though, that can be a disadvantage), and the ability
to create a filled-in plot, something not (easily?) possible with a XY
chart.

The big disadvantage is that whatever one wants to do must be accomplished
in theta = 0 to 2*Pi -- though, I am hesitant to make a claim that you might
decide to prove wrong. {grin}

That precludes something like the butterfly plot given by

x=COS(t)*(EXP(COS(t))-2*COS(4*t)-SIN(t/12)^5)
y=SIN(t)*(EXP(COS(t))-2*COS(4*t)-SIN(t/12)^5)

for 0lt;= t lt;= 24*Pi

--
Regards,

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

In article gt;,
says...
gt; Hi,
gt;
gt; These maybe of interest to you.
gt; www.andypope.info/charts/polarplot2.htm
gt; www.andypope.info/charts/polarplot.htm
gt;
gt; Cheers
gt; Andy
gt;
gt; Wes12 wrote:
gt; gt; How do you plot an R-Theta chart in Excel, i.e. a circular chart with the
gt; gt; independent axis (angle) in degrees from 0 to 360 degrees and amplitude as
gt; gt; the radial distance from the center point?
gt;
gt;

Hi Tushar,

You are correct, any plot which includes values greater the 2*Pi
requires the use of multiple series.

Cheers
Andy

Tushar Mehta wrote:
gt; Hi Andy,
gt;
gt; I've shied away from using a Radar plot for parametric plots because I've
gt; always seen it as more like a Line chart turned into a circle rather than a
gt; XY Scatter chart.
gt;
gt; But, as you demonstrate, it does have some advantages. There's no need to
gt; specify theta values (though, that can be a disadvantage), and the ability
gt; to create a filled-in plot, something not (easily?) possible with a XY
gt; chart.
gt;
gt; The big disadvantage is that whatever one wants to do must be accomplished
gt; in theta = 0 to 2*Pi -- though, I am hesitant to make a claim that you might
gt; decide to prove wrong. {grin}
gt;
gt; That precludes something like the butterfly plot given by
gt;
gt; x=COS(t)*(EXP(COS(t))-2*COS(4*t)-SIN(t/12)^5)
gt; y=SIN(t)*(EXP(COS(t))-2*COS(4*t)-SIN(t/12)^5)
gt;
gt; for 0lt;= t lt;= 24*Pi
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Thanks, Great work. I have already satisfied my need by building a
bare-bones chart using the r*sin(a) and r*cons(a) method. Just wanted to
plot a scatter chart of wind speed vs. compass direction from my new weather
station. I don't know if this will work, but you can try viewing it as a .jpg
picture at ftp://wboyer.net/Polar Chart/ .

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; These maybe of interest to you.
gt; www.andypope.info/charts/polarplot2.htm
gt; www.andypope.info/charts/polarplot.htm
gt;
gt; Cheers
gt; Andy
gt;
gt; Wes12 wrote:
gt; gt; How do you plot an R-Theta chart in Excel, i.e. a circular chart with the
gt; gt; independent axis (angle) in degrees from 0 to 360 degrees and amplitude as
gt; gt; the radial distance from the center point?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;