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
Gantt Chart Excel

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 our Gantt Chart Excel template and Save the file to your desktop folder. Open the Gantt Chart Excel template and Enable Macros

gantt chart excel template macros

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 worksheet with a new Gantt chart timeline is created for you! 

Gantt Chart template timeline

  • The project name, lead  and project budget shows up on the top left
  • new task is also added by default so that it is easy for you to get started.

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 a task to open it in the form view.

Gantt Chart Template Task Details

In addition, you can set a task resource, estimated start and end dates, baseline and actual start and end dates. You can also use the Gantt chart excel template to keep track of costs including estimated, baseline and actuals, therefore making it an excellent budget and costs planner.

Task notes can also be captured to include a short description to your task to clarify its purpose or scope and to provide additional info to everyone involved.

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

Milestones will help you track major project goals, phases and deadlines.

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

Additional Features of our Gantt Chart Excel Template

Gantt Excel Ribbon
Using this gantt chart excel template is very straightforward. There are buttons on the Gantt ribbon to add Gantt charts, Tasks, Milestones and you can also use Keyboard Short-cuts to create Gantt Charts in Seconds.

Gantt Excel Template Ribbon

Create Elegant Timelines with the Right Amount of Detail
You can show any info within the gantt timeline bars to communicate more important details such as task names, resources, task percent complete, costs etc.

Gantt Chart Excel Timeline Bars

Uber Cool Project Management Dashboards
Keep all interested parties in touch with the status of your project – from team members to project sponsors and top management, a dashboard is the best way to easily communicate key project details.

Gantt Chart Excel Dashboard

Costs Module – Account for Project Budgets & Task Costs
Our Gantt chart excel template allows users to track costs and expenditures for projects and tasks.

Gantt Chart Excel Costs

Milestones
Ability to add and display Milestones in the Gantt Chart.

Gantt Chart Excel Milestones

Task Progress Indicators
Show Task Progress with % complete in the Grid and in the Gantt Chart Timeline.

Gantt Chart Excel Task Percent Status

Holiday Calendar
Set the holiday calendar to exclude holidays in the Gantt chart.

Gantt Chart Excel Holiday Calendar

Configure Work Days
The tool automatically calculates and accounts for the workdays selected.

Gantt Chart Excel Work Week

Parent & Child Task Relationship
Ability to Set Parent & Child Tasks.

Gantt Chart Excel Parent Child Task Relationship

Task Grouping
See the bigger picture or get into the details.

Task Grouping - Expand & Collapse Groups

Filter tasks
Filter by Planned, In-Progress and Completed tasks.

Gantt Chart Excel Filter Tasks

Resource Cost Module
Ability to select resources for tasks and assign costs.

Gantt Chart Excel Costs

Daily, Weekly and Monthly Views
Instantly switch between Daily, Weekly and Monthly Views.

Gantt Chart Excel Calendar Views

Scroll Timeline
Ability to scroll the timeline to the start, today or to the end of the project.

Gantt Chart Timeline Scroll

Double Click
Double click to add, edit or view task details.

Tasks Double Click

Keyboard Shortcuts
Increase your productivity.

Gantt Excel Shortcut Keys

 Intuitive Forms to Add Tasks & Milestones

Gantt Chart Task Form