How do I create a Gantt Chart in Excel?

Find out how to make a Gantt Chart using Microsoft Excel – as used by professional project managers.

How do I create a Gantt Chart in Excel?

1. Set your timeline across the top. Each column should be a time unit – e.g. week / month.
2. Allocate a row underneath the timeline for “Milestones“.
3. Setup a row for each deliverable, as a list of line items underneath your Milestones row.
4. Make the first column larger to allow for deliverable titles.
5. Set out your deliverables in the rows arranged in time order, with the first one at the top.
6. Alternate the rows with two different colours or shades so that they are easy to differentiate at a glance.
7. Test it on a friend. Ask them “Is this easy to understand?” and optimise it with their feedback.Gantt Chart Template for Excel and Google Sheets

Avoid common Gantt mistakes

  1. Don’t make your Gantt Chart too complex! It should fit on one side of A4.
  2. Keep it up to date! Things change as a project rolls out, so make sure you update it regularly.
  3. Keep the number of milestones manageable! Too many milestones makes people lose focus.

Example Excel Template

Excel Gantt Chart Template – 4 Workstreams, Multiple Deliverables, and 2 years Timeline.

Short on time?

Use these templates to help with business best practice:

Business Topics

Template Types

Related Business Best Practices

How do I make an Excel Product Roadmap?

Create a simple Excel Product Roadmap using normal Excel editing tools.

Read more

All Business Best Practice

See all Business Best Practice here.

Published :

Last Updated : September 29th, 2020