Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I draw an ellipse on excel, or can I?
2,062 views
Skip to first unread message
M
Apr 9, 2010, 2:55:01 PM4/9/10
to
Hey,
I need to graphically display data in an ellipse. I was wondering can i do
so from the chart option in excel? or can it be done at all on excel?
Thanks
I need to graphically display data in an ellipse. I was wondering can i do
so from the chart option in excel? or can it be done at all on excel?
Thanks
M
David Biddulph
Apr 9, 2010, 3:27:33 PM4/9/10
to
The chart option in Excel can chart a series. Use the XY (misleadingly
labelled "scatter") chart, not line chart.
If you want a series for an ellipse, you could remember that the equation
for an ellipse could be (x/a)^2+(y/b)^2=1
--
David Biddulph
labelled "scatter") chart, not line chart.
If you want a series for an ellipse, you could remember that the equation
for an ellipse could be (x/a)^2+(y/b)^2=1
--
David Biddulph
"M" <M...@discussions.microsoft.com> wrote in message
news:EB9F11CD-9AD6-4743...@microsoft.com...
Bernard Liengme
Apr 9, 2010, 4:32:34 PM4/9/10
to
While David has given you a perfect mathematical approach, here is a slight
cheat
Plot a circle and then stretch the x dimension
x y
-1 0
-0.9 0.435889894 =sqrt(1-a2^2)
...
.1
.2
....
.9
1
.9 -0.435889894 =-sqrt(1-a2^2)
cheat
Plot a circle and then stretch the x dimension
x y
-1 0
-0.9 0.435889894 =sqrt(1-a2^2)
...
.1
.2
....
.9
1
.9 -0.435889894 =-sqrt(1-a2^2)
....
-1
You should use smaller increments around the 1 and -1 values for x to get a
smoother curve
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"M" <M...@discussions.microsoft.com> wrote in message
news:EB9F11CD-9AD6-4743...@microsoft.com...
0 new messages