Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have equipment operators with various starting and ending times. E.g. Some
at 5:00, some at 6:00, and some at 7:00. The 5s work 5:00 -1:30, the 6s work 6:00 €“ 2:30, and the 7s work 07:00-3:30 , all 8 1/2/ hour blocks. Id like to bar the range theyre working, e.g. a bar for Employee A running from 5-1:30, Employee B from 6 €“ 2:30, etc. so that I could easily, visually see the amount of time they overlap. Something like below, so I could see that I have 3 employees that overlap from 7:00 €“ 1:30, etc. 5 7 9 11 1 3 A Xxxxxxxxxxxxxxxxxxxxxxx B Xxxxxxxxxxxxxxxxxxxxxxx C Xxxxxxxxxxxxxxxxxxxxxxxxx I'm not very versed in charting, but I can chart the start time and the end time, Ijust can't figure out how to chart the 8 1/2 hours working at a particular starting time. Any help would be appreciated. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workhours Calculation | Excel Worksheet Functions | |||
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? | Charts and Charting in Excel | |||
bars | Charts and Charting in Excel | |||
Lost all my menu bars and tool bars | Excel Discussion (Misc queries) | |||
of Named Ranges, Dynamic Charts and scroll bars... | Charts and Charting in Excel |