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?

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?

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?