Excel Gantt Chart Generator
Build a Gantt chart workbook with a shaded bar for every task across a dated timeline.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Project Plan | ||||||||
| 2 | |||||||||
| 3 | Task | Start (day) | Duration (days) | Finish | 1/9 | 2/9 | 3/9 | 4/9 | 5/9 |
| 4 | Discovery | 0 | 5 | =B4+C4 | |||||
| 5 | Design | 5 | 8 | =B5+C5 | |||||
| 6 | Build | 12 | 15 | =B6+C6 | |||||
| 7 | Test | 25 | 6 | =B7+C7 | |||||
| 8 | Launch | 31 | 2 | =B8+C8 | |||||
| 9 | |||||||||
| 10 | The bars are cell fills written at generation time. Editing a start or duration updates the Finish column, but the bar stays where it is - regenerate here, or drag the fill across in Excel. | ||||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | Timeline starts 2026-09-01 | ||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 |
Preview of the first 22 rows. Cells shown as =SUM(...) are live formulas in the downloaded workbook, not pasted numbers.
What you get
- •One row per task with its start, duration and finish, and a shaded bar across the timeline.
- •A dated header so the timeline reads as real dates rather than day numbers.
- •Optional weekend shading, and a bordered grid so the bars read as a chart.
- •Finish is a formula, so changing a start or duration moves the finish date with it.
- •The bars are cell fills written when you generate, not a live rule - edit the plan here and regenerate.