I am trying to set up a employee shift schedule with a floating bar chart for
approx. 30 employees. I can get the bar to start at the right time, but it
does not end at the correct time. How can I accomplish this? I have to
print out a daily schedule on a weekly basis so I would like to create a
reusable chart for this function. I am using Excel and Powerpoint. Thanks
for your help.

Hi,

Have a read of Jon's article on Gantt charts.
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

He also has a collection of links on the subject.
http://peltiertech.com/Excel/Charts/GanttLinks.html

Cheers
Andy

Charlotte Shaddix wrote:
I am trying to set up a employee shift schedule with a floating bar chart for
approx. 30 employees. I can get the bar to start at the right time, but it
does not end at the correct time. How can I accomplish this? I have to
print out a daily schedule on a weekly basis so I would like to create a
reusable chart for this function. I am using Excel and Powerpoint. Thanks
for your help.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info