Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mile
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw cumulative frequency curve in Excel Alvin Charts and Charting in Excel 2 April 23rd 23 09:03 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Hyperlink to specific worksheet in Excel Glenn Mulno Links and Linking in Excel 2 February 7th 05 06:01 PM
How do I easily draw in Excel the Upper and Lower limits of a con. Judy Charts and Charting in Excel 3 January 12th 05 09:21 AM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"