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.
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.
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.