Today I am going to show you how to create a dynamic Gantt chart in excel 2007.

A Gantt chart helps you plan and track various elements of a project. A dynamic chart automatically adds new values to the chart. Let´s start!

Instructions:

Create a table

1. Select cell range (A1:D7)
   
2. Click "Insert" tab on the ribbon
3. Click "table" button
4. Click ok!

Create a stacked chart

1. Select table
2. Go to "Insert" tab
3. Click "Bar chart" button and then click "Stacked bar" button.

Setting up the stacked chart

1. Right click a blue bar
   
2. Click "Format Data Series..."
3. Click "Fill"
4. Click "No Fill"
5. Click OK!
   
6. Right click on chart
7. Click "Select Data"
   
8. Select "Finish Date"
9. Click "Remove" button
10. Click OK!

Format x-axis

1. Right click on x axis dates
   
2. Click "Format axis.."
   
3. Change "Minimum:" and "Major unit:" to fixed
4. Change "Minimum" value to 40547.
5. Change "Major unit:" value to 7.
   
6. Click "Alignment"
7. Change "Text direction:" to Rotate all text 270
8. Click Close

Setting up the legend

1. Left click text "Start date" in legend
2. Delete
3. Right click on chart
4. Click "Select Data"
5. Click "Duration"
6. Click Edit
   
7. Change "Series name:" to Sheet4!$A$1 (Activity)
8. Click OK!

Download excel 2007 *.xlsx file

Dynamic Gantt Chart.xlsx

Recommended links:

How to create a dynamic chart
Gantt Charts – Project Management Using Excel [Part 1 of 6] (Chandoo.org)
Gantt charts in excel (PDF by John Walkenbach)
Gantt charts (Wikipedia)

Related posts:

Advanced Gantt Chart Template

Excel charts: Use dynamic ranges to add new values to both chart and drop down list

Excel 2007: How to create a dynamic chart

Excel charts: Multiple series and named ranges

Creating transparent bars in excel 2003 and excel 2007 charts