Create chart shaped like a clock

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ragdpragdp@gmail.com - 16 Oct 2006 21:06 GMT

I'm an excel newb and am trying to create a chart shaped like a clock.
The idea is that I would enter a time someone did something and a dot
would appear at the appropriate place. This way, you could look at the
chart and say, "Oh look - most people do (x) at 3:30 though a few do it
at 12:45 and not too many people do (x) at night." Does that make
sense? Is it a scatter chart in the shape of a clock? How would I do
that? Thanks!

Reply to this Message

Andy Pope - 17 Oct 2006 15:36 GMT

Hi,

To plot the points assuming 12 hour clock and not 24. That is 00:00 and
12:00 share the same position on the plot.

A2: =00:00
B2: =COS(RADIANS(450-(720*A2)))
C2: =SIN(RADIANS(450-(720*A2)))

Drag down for required time points. Plot as xyscatter with min and max
scale values of +/- 1.5

For other clocks see here
http://www.andypope.info/fun/clocks.htm

Cheers
Andy

> I'm an excel newb and am trying to create a chart shaped like a clock.
> The idea is that I would enter a time someone did something and a dot
[quoted text clipped - 3 lines]
> sense? Is it a scatter chart in the shape of a clock? How would I do
> that? Thanks!

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message