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.

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.

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