Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Creating Circles on Excel Graphs

I'm making a spreadsheet that shows the circumcenter of a triangle
with the 3 points as input from the user. I can get the circumcenter
calculated no problem, but now I want to make 1 circle radiating from
the point the user has input that will also cross the circumcenter
point.

Say the point the user enters is 1,1 and the circumcenter is a 2,2. I
want a circle that's center is at 1,1 and crosses through point 2,2.

Any ideas?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default Creating Circles on Excel Graphs

First find the radius.
Length of a line = SQRT((x1-x2)^2 - (y1-y2)^2)
In your case R =1
Make a table of x values (think about what range they should be in)
Next each compute the Y values using y=SQRT(x^2-r^2) for each X value; note
you could have + and - values
Make an XY chart of the table
Please acknowledge this newsgroup on you homework hand-in
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
I'm making a spreadsheet that shows the circumcenter of a triangle
with the 3 points as input from the user. I can get the circumcenter
calculated no problem, but now I want to make 1 circle radiating from
the point the user has input that will also cross the circumcenter
point.

Say the point the user enters is 1,1 and the circumcenter is a 2,2. I
want a circle that's center is at 1,1 and crosses through point 2,2.

Any ideas?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6,582
Default Creating Circles on Excel Graphs

Please acknowledge this newsgroup on you homework hand-in
LOL

R = SQRT(2), right Bernard?

I answered this in a different forum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Bernard Liengme" wrote in message
...
First find the radius.
Length of a line = SQRT((x1-x2)^2 - (y1-y2)^2)
In your case R =1
Make a table of x values (think about what range they should be in)
Next each compute the Y values using y=SQRT(x^2-r^2) for each X value;
note you could have + and - values
Make an XY chart of the table
Please acknowledge this newsgroup on you homework hand-in
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
I'm making a spreadsheet that shows the circumcenter of a triangle
with the 3 points as input from the user. I can get the circumcenter
calculated no problem, but now I want to make 1 circle radiating from
the point the user has input that will also cross the circumcenter
point.

Say the point the user enters is 1,1 and the circumcenter is a 2,2. I
want a circle that's center is at 1,1 and crosses through point 2,2.

Any ideas?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Circles in an Excel Graph [email protected] Excel Discussion (Misc queries) 2 February 23rd 07 03:36 AM
Question About Creating Graphs in Excel 2003 Razor Charts and Charting in Excel 2 January 31st 07 06:20 PM
Excel has turned my circles into ovals. [email protected] Excel Discussion (Misc queries) 0 July 20th 06 01:45 PM
Creating two bar graphs Lisa Charts and Charting in Excel 3 December 6th 05 01:41 PM
Creating a chart of overlaid area circles? m.nutt1 Charts and Charting in Excel 3 November 25th 05 01:05 PM


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"