1. Home
  2. Blog
  3. How to make a Gantt chart in Excel: a 6-step method

How to make a Gantt chart in Excel: a 6-step method

Published on · Pilotis

The Gantt chart remains the most widely used planning tool, because anyone can read it without training. Excel is enough for most projects, provided you follow a method and keep the schedule alive.

Schedule and controlGantt · milestones · critical path S1S2S3S4S5S6S7S8ScopingPlanningDeliveryTestsAcceptanceClosure Critical path ■ · Progress 46 % Risk matrix Budget 78 % CPI 1,04

1. Start from the deliverables

First list what the project must produce, then break each deliverable into tasks. The work breakdown structure (WBS) avoids forgetting whole parts of the work.

2. Estimate realistic durations

Ask the people who will do the work. For uncertain tasks, use three-point (PERT) estimating: (optimistic + 4 × most likely + pessimistic) ÷ 6. You get a more realistic duration than a single estimate.

3. Link the tasks

For each task, state which tasks must finish before it starts. These links let the schedule recalculate automatically when a task slips.

4. Place the milestones

Milestones are zero-duration checkpoints: specification sign-off, delivery, commissioning. They structure reviews and communication with management.

5. Find the critical path

The critical path is the longest chain of linked tasks. Any task on it that runs late pushes back the end of the project; the others have float. Colour it to see it at a glance.

6. Update every week

  • Record the actual progress of each task under way
  • Move the “today” line
  • Compare with the baseline to measure variances
  • Decide on actions for late critical tasks

A schedule that is not updated becomes wrong within three weeks.

The tool to take action

Schedule and milestones

The Gantt chart that shows each task on a time scale, with the milestones not to miss.

See the tool

Or try it free: Estimate a duration with PERT