On my other web site there is a page that describes in detail how to prepare a basic Gantt Chart using a spreadsheet. The other day Tony Miller wrote and asked me if I could prepare a Gantt Chart in which the bars are different colours. So, your wish is my command: take a look at this video file and see how it’s done!

You will find other examples in Chapter 15 of my book, The Excel Project: Excel for Accountants, Business People … from the Beginning, that will help you to use the techniques you need to build this chart in your other work.

The link that follows takes you to a page in my ExcelMaster website. Gantt Charts with Coloured Bars.

Duncan Williamson

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: