Author: Oscar Cronquist Article last updated on February 14, 2019

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!

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 file

Enter your email to receive the workbook.
* You will also get a weekly newsletter, unsubscribe anytime!