ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to draw a circle in excel with specific radius (https://www.excelbanter.com/excel-worksheet-functions/83049-how-draw-circle-excel-specific-radius.html)

Mile

How to draw a circle in excel with specific radius
 
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.

Arvi Laanemets

How to draw a circle in excel with specific radius
 
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.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Mile" wrote in message
...
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.





All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com