How to Create a Gantt Chart in Excel 2007, 2010, 2013 & 2016?

This step-by-step tutorial will show you how to make professional Gantt charts in Excel

Gantt Chart Excel Template Ribbon

Which tutorial would you like to see?

Automatically Create a Gantt Chart in Excel

Our automated excel template tutorial takes approximately:

0 Minutes
Manually Create a Gantt Chart in Excel

The manual excel tutorial takes approximately:

0 Minutes
Automatically Create a Gantt Chart in Excel

1. Download and Save the file to your my documents/ desktop folder. Open the file and Enable Macros

gantt chart enable

2. Click on the Add Gantt chart button, enter project details and click the Ok button

Add Gantt Chart add-gantt-chart-project-popup

3. Instantly, a new Gantt chart worksheet with a timeline is created for you! A new task is also added by default so that it is easy for you to get started.

Gantt Chart template timeline

4. You can just type in the grid to create new tasks. WBS automatically updates.

Gantt Chart Template Add New TasK

You can also double click the task to open it in the form view.

Gantt Chart Template Task Details

5. You can also use the Add buttons in the Gantt tab to add tasks and milestones. This feature is helpful to insert tasks at selection or under selection.

Gantt Chart Template Add Task Buttons

From here you can easily customize the Gantt chart, adding milestones, task dependencies,  changing timeline colors, and adding various details like percent complete, costs etc…  With some tweaks, you can create a timeline that’s sure to impress:

Gantt Chart Excel Template

And that’s how easy it is to create Gantt charts in Excel

Get started by downloading our free gantt chart excel template…

DOWNLOAD GANTT CHART EXCEL TEMPLATE