Creating Circles in an Excel Graph

[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?

 

[Guest]

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

 

[Jon Peltier]

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