Time Graph - Is this even possible?

[waltherg]

Could someone help me create this graph? The problem is kind of hard to explain...

I would like a graph with the x axis stating a range of times (7AM to 10PM)

The Y axis would show a shaded histogram-type graph displaying the time range that several employees work.

For instance, if I work 10AM to 5PM tomorrow and someone else works 7:30AM to 3PM... I would like the graph to display a spread so that we can see where the two employees overlap.

ME ----------------------- ||||||||||||||||||||||||||||||||
SOMEONE --------- |||||||||||||||||||||||||
SOMEONE2---------------------------- |||||||||||||||||||||||||||||||||

TIME:---------- 7AM ------------------------------------------------10PM

Please ignore the dashes.Anyone have any idea if this is possible with excel?

Thanks in advance,
Greg W

 

[shg]

      ---A--- --B-- -C-- --D-- ----E-----
  1           Start Dur   End            
  2   Me      10:00 7:00 17:00 C2: =D2-B2
  3   Someone  7:30 7:30 15:00

You can plot columns B and C as a stacked bar chart, and format the first series to have no fill or border.

 

[waltherg]

      ---A--- --B-- -C-- --D-- ----E-----
  1           Start Dur   End            
  2   Me      10:00 7:00 17:00 C2: =D2-B2
  3   Someone  7:30 7:30 15:00

You can plot columns B and C as a stacked bar chart, and format the first series to have no fill or border.

I should have mentioned... I'm far from an expert. However, even when I select just one "person's" hours, and create a stacked bar graph - I still end up with two bars. one for the numerical representation of the time, and another for the duration. Any idea what I am doing wrong?

 

[shg]

Right -- the purpose of the first series is just to displace the second to the proper starting position. That's why you make it have no fill or outline, so you don't see it.

 

[PaddyD]

you could use this approach:

http://www.mrexcel.com/articles/gantt-chart-with-conditional-formatting.php

 

[Jon Peltier]

I wrote about this a while back:

Gantt Charts in Excel