Staffing bar chart for restaurant staffing
 

My data set looks like:
Position Start Time Duration Start Time Duration
Cook 7 17
Server 11 3 5
5

I want a chart that looks like:

Cook *************************************
Server ******* ************

7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

I seem to be able to only get one series to show (the cook, not the server)
- and I'm not sure how I will be able to create the "broken" bar for the two
separate server shifts.

Thanks for any help someone can give!

The simplest way is to forget charts and use worksheet formatting to "draw"
the schedule. See
http://pubs.logicalexpressions.com/P...cle.asp?ID=343
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"KMo5" wrote in message
...
My data set looks like:
Position Start Time Duration Start Time Duration
Cook 7 17
Server 11 3 5
5

I want a chart that looks like:

Cook *************************************
Server ******* ************

7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

I seem to be able to only get one series to show (the cook, not the
server)
- and I'm not sure how I will be able to create the "broken" bar for the
two
separate server shifts.

Thanks for any help someone can give!