Clock Graph

**lemuel_patrick** · 08-08-2009, 09:14 PM

Hi all,

I need like a sort of pie graph but looks like a clock.

THe data would be something like
3:00 PM to 4:00 PM -- lunchbreak -- red on the clock
4:00 PM to 5:30--- go online --green
5:30 PM to 12:00 AM -- go to work. -- yellow

So it's basically a schedule that is plotted visually on a clock.
Is it possible? Can someone help me with this?

**Palmetto** · 08-08-2009, 09:34 PM

You might start here: http://www.andypope.info/charts/gauge.htm

Another Idea here: Polar clock using donut chart

And here: Plot your data around the clock

**lemuel_patrick** · 08-08-2009, 10:59 PM

this may work Palmetto but how bout for times that aren't exact?
like 1:20 or 1:30.
it would look like something like this..

Originally Posted by Palmetto

You might start here: http://www.andypope.info/charts/gauge.htm

Another Idea here: Polar clock using donut chart

And here: Plot your data around the clock

**lemuel_patrick** · 08-08-2009, 11:00 PM

please check the attachment test.jpeg that charts the data i initially gave...

3:00 PM to 4:00 PM -- lunchbreak -- red on the clock
4:00 PM to 5:30--- go online --green
5:30 PM to 12:00 AM -- go to work. -- yellow

i would appreciate your help for this :_)

**Andy Pope** · 08-09-2009, 07:48 AM

Enter your times in column C and change text in column A

Note the chart will only handle a 12 hour period.

**reynoldsohio** · 01-27-2013, 09:33 PM

greetings,
I'm looking for a similar chart (clock) that has overlapping periods depicting various work periods for the workers in my department. This example is actually a PIE chart with names....I'd like to use something like a DONUT ring that overlaps others as workers overlap.

Thanks for any assistance...shoot me a note anytime.

**arlu1201** · 01-28-2013, 02:48 AM

reynoldsohio,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.