View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Brandon Brandon is offline
external usenet poster
 
Posts: 58
Default Grouping by the hour

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