View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Bars for various ranges of workhours

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,