Prev: Charts are Shrinking
Next: Time-date chart plotting
From: M on 9 Apr 2010 14:55
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
From: "David Biddulph" groups [at] on 9 Apr 2010 15:27
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


"M" <M(a)discussions.microsoft.com> wrote in message
news:EB9F11CD-9AD6-4743-925A-F42DB5241CDD(a)microsoft.com...
> 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


From: Bernard Liengme on 9 Apr 2010 16:32
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" <M(a)discussions.microsoft.com> wrote in message
news:EB9F11CD-9AD6-4743-925A-F42DB5241CDD(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Charts are Shrinking
Next: Time-date chart plotting