Bars for various ranges of workhours

[Steve]

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 5’s work 5:00 -1:30, the 6’s
work 6:00 – 2:30, and the 7s work 07:00-3:30 , all 8 1/2/ hour blocks.
I’d like to bar the range they’re 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,

 

[Andy Pope]

Hi,

Have read of Jon's article on gantt charts.
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

Cheers
Andy

 

[Shane Devenshire]

Hi Steve

If they are all 8.5 hour block here is a simple way to set it up in

2007:
1. Enter the operator names in column A
2. Enter their start times in column B
3. In column C enter the formula =B1+8.5/24 and fill it down
4. Select the entire range and choose Insert, Bar, Stacked Bar
5. With the chart selected choose Chart Tools, Design, Switch Row/Column
6. Select the first series, the one on the left and choose Chart Tools, Format, Shape Fill, No Fill and then Shape Outline, No Outline

2003:
1. Set up the data as in steps 1-3 above
2. Select the range and click the Charting toolbar button
3. choose the Custom Types tab, then Floating Bars and click Next
4. Choose Series in Column (if necessary depending on your data layout.
5. Click Finish

Cheers,
Shane Devenshire
Microsoft Excel MVP

 

[Steve]

I think I have it, but a few more questions. I am using 2007, and have only
had it a couple of months, and am not very comfortable with it yet. The x
axis' range is 0:00 -12:00 - 0:00 - 12:00 - 0:00 - 12:00.
How can I get just the one range of e.g., 0:00 - 00:59
Also, and I don't think it's an optical illusion, but the 05:00 - 7:00
employees range length is only appx. 2", whereas all the other ones range
length is appx. 3". Could that also be due to the x axis range of repeated
values ?

Much thanks,

Steve