ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Set begin/end times in a bar chart (https://www.excelbanter.com/charts-charting-excel/105263-set-begin-end-times-bar-chart.html)

Charlotte Shaddix

Set begin/end times in a bar chart
 
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

Set begin/end times in a bar chart
 
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


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com