Creating Circles on Excel Graphs

  • Thread starter Thread starter theelitegoldfish
  • Start date Start date
T

theelitegoldfish

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?
 
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
 
Please acknowledge this newsgroup on you homework hand-in
LOL

R = SQRT(2), right Bernard?

I answered this in a different forum.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top