Hey guys,
Im in the middle of improving my excel spreadsheet which keeps track of what employees are rostered and when.

At the moment, Employees are in Column A, then is goes MONDAY, Column B is start time, Column C in Finish time and Column D is how many hours that employee is working on that day (i.e. D = C - B).

What I want to do it make a line graph where the X axis is the hours we are open (i.e. 11am - 11pm). The Y axis is the employees names and then there is a line for each employee. The line starts and finish with the employees Start Time and Finish time, and obviously it will be a straight line.

If anyone can help me this would be really great!

Thanks in advance,
Regan