Gantt chart not displaying properly

kpk

New member
Joined
Mar 13, 2013
Messages
2
Reaction score
0
Points
0
Hi,
I'm trying to make a Gantt chart using Excel. I was able to create one but it's not displaying correctly. The task bars should be butted up against each without spaces between them. In other words the end date of one task is the start date of the next one. The data driving the chart is set up like that, but for some reason the bars don't go far enough over to the beginning of the next task. How do I get rid of these spaces?


Common Photonics Clamp Project Plan.jpg


I'm also attaching the excel file itself.

-Kris
 

Attachments

  • Common Photonics Clamp Project Plan.xlsx
    16.4 KB · Views: 41
Hmmm. It opens nicely on my system. Here it is again.
 

Attachments

  • Common Photonics Clamp Project Plan.xlsx
    16.4 KB · Views: 37
3/5/2013 + 20 days is 3/25/2013 and will not correspond to the next start of 4/2/2013. You are mixing workdays and regular days, so the weekends are being ignored for your start dates, but not for the total days...

If you want them to correspond, you might need to adjust column E formula to: =WORKDAY(B7,D7*5)-B7 so that you get 28 full days... and will buy up to 4/2/2013 start of next task.
 
Back
Top