Make a pivot table of the data, with time in the row area and (sum of) usage
in the data area. Group the time field by hours:
Sum of usage
time Total
8 AM 0
9 AM 6
10 AM 3
11 AM 3
12 PM 1
1 PM 4
2 PM 2
Grand Total 19
Make a chart from this data.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Brandon" wrote in message
...
I would like to bar chart a room usage count by the hour. When the room is
checked anytime during the hour it is added to the total for the hour. On
the
"Y" axis is the room usage count and on the "X" axis is the hour of the
day.
How should I go about doing this, considering the data below? (e.g. a bar
would extend to the point 9:00 AM and 6)
TIA for the help.
-Brandon P
time roomusagecount
8:41 AM 0
8:45 AM 0
9:30 AM 1
9:35 AM 0
9:35 AM 0
9:35 AM 1
9:40 AM 2
9:53 AM 2
10:10 AM 0
10:15 AM 1
10:15 AM 2
11:18 AM 1
11:31 AM 0
11:33 AM 2
12:56 PM 1
1:10 PM 2
1:10 PM 2
2:00 PM 1
2:09 PM 1