Time Chart.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

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

13:00 - 13:30, 13:30 - 14:00, 14:00 - 14:30
 
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!!
 
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
Click to expand...
C. Repeat for the rest of your columns.

- Jon
 
Back
Top