How the Excel template works
This template uses the classic stacked-bar method of building a Gantt chart in Excel. There is no special add-in and no macro. Each task row has three inputs: a Task name, a Start date, and a Duration in days. A horizontal stacked bar chart sits alongside the table, with the first (transparent) series pushing each bar to its start date and the second (colored) series representing the duration. When you change a date or a duration, the bar moves and resizes automatically.
If you would rather see exactly how the stacked-bar trick is set up from scratch — including the two data series and how to hide the spacer bars — read our step-by-step guide on how to make a Gantt chart in Excel.
What's included
The download is a single worksheet pre-built with a sample project so you can see the structure and replace it with your own:
- A task table with columns for Task, Owner, Start date, Duration (days), End date and % Complete.
- Phase grouping — a few example phases (Planning, Build, Review, Launch) with tasks nested underneath.
- An auto-drawing stacked bar chart that reads the table and renders the timeline.
- Milestone markers shown as zero-duration rows you can point to a key date.
- A weekend/today reference so you can eyeball where "now" falls against your plan.
How to customize it
- Replace the sample tasks. Overwrite the example task names with your own, keeping one task per row.
- Set start dates and durations. Enter a real start date and a duration in days for each task; the end date and bar update automatically.
- Add or remove rows. To add a task, insert a row inside the existing range and copy the formulas down so it's picked up by the chart.
- Group into phases. Use bold header rows to mark phases and indent the tasks beneath them for a clean work-breakdown structure.
- Recolor the bars. Click any bar series and change the fill to match your team's or project's colors.
Tips for scheduling in Excel
Excel is great for a static snapshot but has real limits as a scheduling tool — keep these in mind:
- Durations vs. dates. Drive the chart off start date + duration, not hard-coded end dates, so that pushing one task forward is a single edit.
- Watch the data range. The most common mistake is adding tasks below the charted range so they never appear. Always insert inside the range.
- No automatic dependencies. If Task B should start when Task A finishes, Excel won't move it for you — you'll re-key dates by hand every time the plan slips. That's exactly what the online editor automates.
- Keep working days in mind. A plain duration counts calendar days including weekends; adjust manually or use the online editor's working-day calendar.
Related templates
- Google Sheets Gantt chart template — the same layout for a free, shareable cloud spreadsheet.
- PowerPoint Gantt chart template — a slide-ready timeline for status decks.
- Project management template — a fuller five-phase plan with milestones.
Frequently asked questions
Does the Excel Gantt chart template work in older versions of Excel?
Yes. The template uses a standard stacked bar chart and basic formulas, so it works in Excel 2010 and later, Excel for Microsoft 365, and Excel for Mac. It also opens in Google Sheets and LibreOffice Calc.
How do I add more tasks to the Excel template?
Insert a new row inside the existing task range and fill in the task name, start date and duration. Copy the formulas from the row above so the new task is included in the chart data range.
Is the Excel Gantt chart template free?
Yes, it is completely free to download and use with no sign up. You can also open it in our free online editor and export to PDF, PNG, Excel or PowerPoint at no cost.
Can I show dependencies and the critical path in Excel?
Excel does not calculate dependencies or the critical path automatically. If you need those, open the template in the free gantts.app editor, which links dependencies and highlights the critical path for you.