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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"M" <(E-Mail Removed)> wrote in message
news:EB9F11CD-9AD6-4743-925A-(E-Mail Removed)...
> 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