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.
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