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.

Answer

  1. Firstly, set your timeline across the top. Each column should be a time unit – e.g. week / month.
  2. Secondly, allocate a row underneath the timeline for “Milestones”.
  3. Then, 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. Alternate the row colour with 2 light shades of grey to make it easy to read.
  6. Set out your deliverables in time order, first one at the top.
  7. Plot your deliverables in the rows, using at least 2 different colours so that they are easy to understand when you glance at the Gantt.

By . Published: 2019/09/29 8:55:13 AM, Last Updated: 2019/09/29 3:48:18 PM

More detail

Avoid common 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

Gantt Chart Template for Excel and Google Sheets

A simple Excel Gantt chart template to show 2 workstreams.

Short on time?

try one of these templates:

Related Questions

See all Questions

FAQ Created: 2019/09/29 8:55:13 AM, Last Updated: 2019/09/29 3:48:18 PM By .