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?