Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating Circles in an Excel Graph | Excel Discussion (Misc queries) | |||
Question About Creating Graphs in Excel 2003 | Charts and Charting in Excel | |||
Excel has turned my circles into ovals. | Excel Discussion (Misc queries) | |||
Creating two bar graphs | Charts and Charting in Excel | |||
Creating a chart of overlaid area circles? | Charts and Charting in Excel |