Creating a Gantt Chart with Excel is Getting Even Easier

by on December 5, 2012

 |   Email |  
 Print |  
 Share |  
Post image for Creating a Gantt Chart with Excel is Getting Even Easier

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)

Gantt Chart Template version 2.3 XLS

Screenshots of the new view controls in Gantt Chart Template PRO, version 2.3 for Excel 2003 (XLS)

Version 2.3 for Excel 2010 (.xlsx)

Gantt Chart Template version 2.3 XLSX

Screenshots of the new view controls for Gantt Chart Template PRO 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.

Feedback

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.

Gantt Chart for Google Sheets
View Larger Image

VN:F [1.9.22_1171]
Rating: 4.3/5 (13 votes cast)
Creating a Gantt Chart with Excel is Getting Even Easier, 4.3 out of 5 based on 13 ratings

{ 39 comments… read them below or add one }

Leave a Comment

Previous post:

Next post: