You're reading...
Project Management

How to create a “half decent” Gantt Chart in Excel

I’ve always thought that Excel was a great tool for planning simple projects.  I’ve coloured in cells and even created formulae and conditional formatting to colour in bars to represent activity durations.

But, I’ve just learnt how to use Stacked Bar Charts to create a Gantt Chart that looks more than half decent.  I’ve even managed to customise it to show duration bars in one colour and milestones (zero duration) in a different colour.

A Gantt Chart in Excel (using Stacked Bar Charts)

A Gantt Chart in Excel (using Stacked Bar Charts)

You can download my demo spreadsheet here and a new fully automated version (2014). If you need help e-mail me.

You can learn the basics here:

And, from Microsoft here.

Other Excel resources:

You can can also download this automated Gantt Chart Template at the link below:

Gantt Chart Excel

Free Gantt Chart template from


Comments are closed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 850 other followers

Connect with Ian Seath

Find us on Facebook Improvement Skills Consulting Ltd. on LinkedIn Follow IanJSeath on Twitter


Copyright Notice

© Improvement Skills Consulting Ltd. and Ian Seath, 2007-22. Unauthorised use and/or duplication of this material without express and written permission from this site’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Improvement Skills Consulting Ltd. and Ian Seath with appropriate and specific direction to the original content.

%d bloggers like this: