Circles
 

I want to create something similar to a round clock face in Excel and I
want to be able to highlight a section say from 12 to 2 in a wedge
shape from center point to perimeter. I can draw the circle but it's
wedges (which will need to increase in size as time goes by) that I
can't do.


--
BABarone
------------------------------------------------------------------------
BABarone's Profile: http://www.excelforum.com/member.php...o&userid=25329
View this thread: http://www.excelforum.com/showthread...hreadid=388181

Would a pie chart work?

"BABarone" wrote:


I want to create something similar to a round clock face in Excel and I
want to be able to highlight a section say from 12 to 2 in a wedge
shape from center point to perimeter. I can draw the circle but it's
wedges (which will need to increase in size as time goes by) that I
can't do.


--
BABarone
------------------------------------------------------------------------
BABarone's Profile: http://www.excelforum.com/member.php...o&userid=25329
View this thread: http://www.excelforum.com/showthread...hreadid=388181

Perhaps a 2 number pie chart (enter 20 in A1, 80 in A2, 'select' the two
cells and Insert, Chart, Pie)

This will normally 'wedge' from 12:00 noon, but rightmouse-click and
you can Format Data Series to move to a 330 degrees axis, and for 30/70
split to a 310 degree offset.

Remove the Legend, and (if needed) hide column A for a picture only
view.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=388181

You could borrow some code from Chip Pearson:
http://www.cpearson.com/excel/download.htm
Look for Clock.



BABarone wrote:

I want to create something similar to a round clock face in Excel and I
want to be able to highlight a section say from 12 to 2 in a wedge
shape from center point to perimeter. I can draw the circle but it's
wedges (which will need to increase in size as time goes by) that I
can't do.

--
BABarone
------------------------------------------------------------------------
BABarone's Profile: http://www.excelforum.com/member.php...o&userid=25329
View this thread: http://www.excelforum.com/showthread...hreadid=388181

--

Dave Peterson