2007: Making a graph to form Roster/Bar Lines

**Regan_Mitchell** · 11-15-2009, 07:51 PM

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

**Regan_Mitchell** · 11-15-2009, 07:54 PM

I forgot to mention, after Column D, Column's E, F, G are repeated from columns B, C, D for Tuesday and the same repitition for Wednesday - Sunday. I would like to make it so I have a different graph for each of these days.

Regan

**Regan_Mitchell** · 11-15-2009, 08:24 PM

Attached is a sample of what I am working with.

**teylyn** · 11-15-2009, 10:05 PM

See attached.

Chart is a stacked bar chart. First series is the values in Start column, second series is the values in HR:MIN column. Hide first series by setting it to no fill, no line

. Now the shift times float.

The x axis is formatted to show 11 am (= 0.458333333) as the minimum and 11 pm (0.958333333) as the maximum, with steps of 1 hour (0.041666667)

hth

**Regan_Mitchell** · 11-16-2009, 01:56 AM

Hey
Just had one quick question. Because I won't have all 20 of my crew on everyday, is there anyway to make only those who are working appear on the sheet?