If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
How do I draw an ellipse on excel, or can I?
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 |
#2
|
|||
|
|||
How do I draw an ellipse on excel, or can I?
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" wrote in message ... 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 |
#3
|
|||
|
|||
How do I draw an ellipse on excel, or can I?
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|