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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: