Previously I posted an Excel Gantt Chart template for Excel 2007 (or 2010). The template works great as is, but it’s hard to reproduce on your own. Here’s the step by step instruction:

Create the chart data

For this example I use the following data:

Task Startdate Fase Activity
DESIGN 5-12-2011 12
module1 5-12-2011 5
module2 12-12-2011 5

 

The Gantt Chart spans weekend dates. The fase Design takes two weeks, which makes the duration 12 days (Mo-Fr + weekend + Mo-Fr).

Manually create the chart

Create a horizontally stacked bar chart. The chart is empty at this point.

Insert first data range and vertical labels

Click on the ‘select data’ button.

  • Add the start date of the fases and activities.
    The label is ‘Start date’. (Important, don’t skip this one).
    The data range is indicated below in yellow.
  • Add the labels
    The data range is indicated below in orange.
Task Start date Fase Activity
DESIGN 5-12-2011 12
module1 5-12-2011 5
module2 12-12-2011 5

The chart now looks like this:

There are a couple of problems here:

  • The chart doesn’t start at the correct start date
    Right click on the X-axis. Change the minimum value to ‘fixed’, value 40882.
    40882 is the decimal representation of Dec the 5th.
  • The X-axis should have a weekly interval
    Right click on the X-axis. Change the primary unit to ‘fixed’, value 7.
  • The Y-axis is reversed
    Right click on the Y-axis. Reverse the categories.

The chart now looks like this:

Add the Fase and Activity data ranges

Manually add both ranges (orange and yellow in the example below).

Task Startdate Fase Activity
DESIGN 5-12-2011 12
module1 5-12-2011 5
module2 12-12-2011 5

The chart now looks like this:

Notice that somehow the chart title ‘Startdate’ has disappeared.

Visually remove ‘startdate’ range

Delete the label ‘Startdate’ from Excel (make the cell empty) and set the bar color and border color to ‘none’.
Of course the Startdate bar and label are still present within the chart, there just invisible!

Optionally, beautify the Gantt chart