How to draw a circle in excel with specific radius

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is ther a way to draw circle trough graf or other option in excel but with
specific radius or if you draw two circle with common center the output look
proportionaly right.
 
Hi

To get a circle of given radius, draw any ellipse using drawing toolbar,
select FormatAutoshape from right-click dropdown menu, and set both width
and heigth of shape to 2*radius. Probably you like to set there the
FillColor to No Fill too.

To set centers of 2 circles to same location, you have temporarily to set
column and row widths/heights to such values, whih divide with diameters of
both circles. Now you can easily adjust location of both circles. After that
restore original widths/heights of columns/rows. When you want to change
circles location afterwards, you have to move them together.
 

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

Similar Threads

Excel Formula for Eclipsing Circles 0
Conditional Formatting on a Drawing? 2
How to get pi to appear in a message box when coded using VBA 0
Drawing on a Chart 1
How can I draw a circle on a graph using point data and the axis? 1
Drawing a Line, Generating the point co-ordinates 1
Rounded textbox/label, circle control? 2
Conditional Formating Circles in a Report - A2003 3

Back
Top