Need to create a project schedule? Try our Gantt Chart Template!

New Gantt Chart for Excel Online

◄ Return to the Gantt Chart Template Page

Today I created a new version of the Gantt Chart Template (Pro) designed to work in Excel Online, Excel 2010+, and Excel for iPhone/iPad. Though quite a few changes were made, most of the functionality is still there.

Screenshot of the Gantt Chart Template for Excel Online.

Screenshot of the Gantt Chart Template for Excel Online.

Completion Status: One of the main differences is that the completion status is shown as a progress bar in the % Done column rather than changing the bars in the chart area.

Customize the Work Week: This version uses the WORKDAY.INTL() and NETWORKDAYS.INTL() functions that let you define exactly which days of the week should be considered non-working days. See the Help worksheet if you want to define the work week as something other than Monday-Friday.

Highlighting the End Date: Another new feature allows you to highlight the End date red when the task is overdue. This feature can be turned on or off in the Help worksheet.

Displaying Dates in d/m/yy Format: Another option in the Help worksheet lets you switch between m/d/yy and d/m/yy display formats. Note that this is only a formatting switch. How you ENTER or EDIT dates will depend on your computer's system settings.

Weekly and Monthly views: Excel Online does not currently support vertically oriented text. It also had trouble with the number of columns that the original XLSX version used. This required a significant change to the way the chart is labeled. A consequence of this change is that the Weekly and Monthly views are less precise, meaning a week or month containing a 1-day task has a bar that is the same length as a week or month containing a 5-day task.

Daily, Weekly, or Monthly Views

Choose a Daily, Weekly, or Monthly View (currently showing the Weekly view)

In the weekly view (shown above), the date shown in the column label is the date for Monday of that week. Another thing to notice in the above screenshot is that the week containing today's date (March 26th) is highlighted green (Monday is March 23rd).

If you want to change the range of dates shown in the chart area, you can change the Display Week number. For example, if the project start date is 1/5/2015, changing the Display Week number to 2 will make the display start at 1/12/2015. In the above screenshot, Display Week 8 means that chart begins with 2/23/2015. In previous versions, changing the range of dates was done using a scroll bar, but scroll bars are not supported in Online Excel.

An Alternate Version, Not a Complete Replacement

This new version is a new download option, but Pro version customers can still download the older versions if they are using older versions of Excel. What you use may depend largely on the version of Excel you and the others on your team are using.

Need help returning to the download page? Follow these instructions.

Have feedback about this version? Please comment below.

Comments

63 comments… add one
  • Hi

    I cant seem to find the switch for the below task.

    Highlighting the End Date: Another new feature allows you to highlight the End date red when the task is overdue. This feature can be turned on or off in the Help worksheet

    Reply
    • Assuming you already checked the Help worksheet thoroughly for that option … which file are you using (the exact filename)? Or email to provide more specific details.

      Reply
  • Right now it shows 8 weeks as the default view and to see the remaining weeks I have to use the upper left and right arrow to see 9th 10the weeks

    how do I change the view so that instead of 8 weeks it shows a total of 9 weeks so that I do not have to use the left and right control to see the 9th week?

    Reply
  • Dear Dr. Wittwer:
    Is there a way to adjust the calendar date range above the progress bars to show the entire assigned project timeline and not extend beyond that? For example, my project is 1 week or 1 month long, I just wanted the dates to show the entire 1 week or 1 month rather than 1 year or 2 years. Thanks in advance for your help.
    Sincerely,
    John Nguyen

    Reply

Leave a Comment

Your Name will be displayed along with your comment. Your Email and IP address are stored with the comment and used to identify/prevent spam (via a service provided by Automattic.com), but are not shared publicly. See our privacy policy to learn more.