Plotting parametric curves

[David D.]

Can I use the Excel chart facility to plot a parametric curve?

For example, the parametric equation for a circle is x=cos(t), y=sin(t).

I have a column for vaious t values from 0 to pi, and computed columns for
=cos(t) and =sin(t).

Now how do I graph that within Excel?

- David

 

[David D.]

That worked fine. It is almost what I was trying to acheive.

I had orginally hilighted all three columns, hoping that the graph would
contain the x,y points, and also the t values (either as axis labels or plot
area labels). But, alas, all I got were sine and cosine graphs.

Your method works ok for me, but it would be helpful if I could also display
the t values for each point. Any suggestions?

Thanks.

- David

 

[Dana DeLouis]

That's even better! Thanks. Looks like a great (and time saving) utility!!
:>)
http://www.appspro.com/utilities/Labeler.asp

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =

Whoa! If I understand the requirement correctly, to add the t-values
for each point as a label, download Rob Bovey's XY Chartlabeler, and
use it to label the plotted series.

<snip>

 

[David D.]

Tushar, Dana,

Wow! What a perfect, made-to-order utility. That is exactly what I
was looking for.

Thanks.



Dana,

Thanks also for thinking outside of the box with your initial proposal.
I will play around with that one, also, just as an exercize to understand
how it works, and to see if it could be easily VBA'd. Maybe I can build
on the concept.



Dan E.,

Thanks for showing me how to correctly specify scatter chart data in
the first place.

- David