PC Review


Reply
Thread Tools Rate Thread

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

 
 
M
Guest
Posts: n/a
 
      9th Apr 2010
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
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      9th Apr 2010
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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Draw an Ellipse on a Report Kaykayme Microsoft Access VBA Modules 4 28th Apr 2009 04:30 PM
Draw ellipse with specify x,y,width, height Slickuser Microsoft C# .NET 4 29th Nov 2007 05:17 PM
how to Draw an ellipse using c# weird0 Microsoft C# .NET 2 16th Oct 2007 11:20 AM
How to draw an ellipse with an rotated angle? Shalley Microsoft VB .NET 4 7th Sep 2003 04:26 AM
Draw Ellipse and store in gif or png file? Nanda Microsoft C# .NET 1 31st Jul 2003 04:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:50 PM.