Time Chart.

[GEM]

How can I group time on the X axis. For example,

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

 

[Jon Peltier]

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

 

[GEM]

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]

Is the data already compiled? Then set it up as in the table under the
"Dynamic Do-It-Yourself Histograms" heading in the page I cited:

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

(about halfway down), but instead of the formulas, just enter your counts.
To make it easier, just enter the time ranges in column A (e.g., enter
13:00 - 13:30 in A2, 13:30 - 14:00 in A3, etc.). Then enter the first set of
counts in column B, the next in C, etc. Make a histogram (column chart) with
the data in A2 to Bwhatever. Copy the chart, go to Chart menu > Source Data

Series tab, and change the range in the Values box from column B to column

C. Repeat for the rest of your columns.

- Jon