Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
Subtracting date:hour from date:hour | Excel Worksheet Functions | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions |