Creating Circles in an Excel Graph
 

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 in an Excel Graph
 

I used the drawing toolbar and added an oval. I did this while recording a
macro and got the following

ActiveSheet.Shapes.AddShape(msoShapeOval, 390.75, 377.25, 72#, 72#).Select

" wrote:

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 in an Excel Graph
 

You know all that you need to define the circle, its center and its radius
(square root of 2). Set up a worksheet range to input coordinates of the
circle, which you will later plot.

A2: =SQRT(2)
B2: 1
C2: 1

A4: Angle
B4: X
C4: Y

In A5 enter 0. in A6 enter 10, select A5:A6 and drag this down to fill down
to A41 with values from 0 to 360. In B5, enter =$B$2+$A$2*SIN(A5*PI()/180),
and in C5 enter =$C$2+$A$2*COS(A5*PI()/180). Select B5:C5 and double click
the little square at the bottom right corner of the highlighting rectangle,
which will fill these formulas down to row 40.

Select A1:B2, create an XY chart, with series in columns. This gives you a
point at (1,1). Copy B4:C41, select the chart, choose Paste Special from the
Edit menu, and choose to add the data as a new series. This is the circle.

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


wrote in message
ups.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?