How do I draw an ellipse on excel, or can I?

[M]

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

M

 

[David Biddulph]

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

 

[Bernard Liengme]

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)

.....
-1

You should use smaller increments around the 1 and -1 values for x to get a
smoother curve
best wishes