Results 1 to 5 of 5

Thread: Gantt chart not displaying properly

  1. #1

    Gantt chart not displaying properly



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?


    Click image for larger version. 

Name:	Common Photonics Clamp Project Plan.jpg 
Views:	45 
Size:	100.0 KB 
ID:	1186


    I'm also attaching the excel file itself.

    -Kris
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    Your workbook is corrupted. Try again.


  3. #3
    Hmmm. It opens nicely on my system. Here it is again.
    Attached Files Attached Files

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    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.


  5. #5
    Excel 2010, Table, PivotTable, PivotChart
    With Gantt Chart
    With modified Workday() formula.
    Ditto NBVC.
    http://58918aa17d4002474361-7ac2b7ee...05_15_13c.xlsx
    If you get *.zip, don't unzip, just rename *.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •