Thanks Jon...

What I need to put on a graph is the time of day when the most work is done
by different users. For example,

User 1
13:00 - 13:30: sold 13 items.
13:30 - 14:00: sold 2 items.
14:00 - 14:30: sold 1 items.

User 2
13:00 - 13:30: sold 14 items.
13:30 - 14:00: sold 1 items.
14:00 - 14:30: sold 2 items.

Here you can see the most work is done from 13:00 - 13:30.

This is a small example, but I need to graph it for about 60 different users
under the same time intervals.

Would you know how???
Thanks!!


"Jon Peltier" wrote:

What's the data like? Are you counting instances within a time frame,
summing them, or what?

Is a histogram what you need?

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GEM" wrote in message
...
How can I group time on the X axis. For example,

13:00 - 13:30, 13:30 - 14:00, 14:00 - 14:30