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
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
Last edited: