Pages

Tuesday, October 30, 2012

How To... Edit a Basic Gantt Chart in Excel 2010

The most popular video on my YouTube Channel is "How to Create a Basic Gantt Chart in Excel 2010" - as I write it has 183,042 lifetime views. A similar video for Excel 2003 has 89,089 views. I get a lot of questions in the comments fields about other things that Excel can do with Gantt charts - usually I suggest to the viewer that they try a "proper" project management software tool like Microsoft Project.

Today I tried to see what else I could do based on feedback received on the channel. In the new video below I show how to link end dates with the start date and duration, change task colours, assign resources, and add labels to Gantt chart tasks. It's a bit of a mish-mash, but hopefully people will find it useful - check out for yourself: