One of the most common requests that I get from users of my Gantt Chart template is the ability to switch the view between daily, weekly, and monthly. The new version of the template provides a solution that is very easy to use. All you do is select the view you want from a drop-down box.
Check out the images below to see the new view-control features:
Version 2.3 for Excel 2003 (.xls)
Version 2.3 for Excel 2010 (.xlsx)
Note: Both files (.xls and .xlsx) will work in Excel 2007+. When using Excel 2007, 2010, or 2013, the .xls file will open in Compatibility Mode.
New Color-Coding Feature in the XLSX Version
The main thing that the XLSX version adds that is not possible to do with Excel 2003 (without adding VBA) is automated color-coding of the bars of the gantt chart.
You will see in the above screenshots that I’ve added a “Color” column where you can enter a color code to choose the color for the bar (“r” = red, “g” = green, etc.).
By using a formula in the Color column, you can automatically color code based on project lead and/or urgency. Example formulas for doing that are included in the spreadsheet.
Please give feedback regarding this new version of Gantt Chart Template Pro. After all, feedback is what led to these new features in the first place.
Update 2/12/2014: In response to a question about the Google Sheets version of Gantt Chart Template Pro, I have posted a screenshot below. This link to the Google Sheets version is included as a bonus with the purchase.