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

  • Thread starter Thread starter M
  • Start date Start date
M

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
 
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
 
Back
Top