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)