A radar chart would work but you need to convert times to degrees.
BTW this is not a programming Q and should have been posted to the
excel.chart newsgroup
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
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!