Project Management
Gantt Chart Excel Template
Excel Gantt with tasks, start/end, duration, % done, owner and visual timeline.
Preview — what you'll download
| WBS | Phase | Task | Owner | Start | End | Duration | Progress | Status | Budget | Spent | Remaining | Spend % | Depends On |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aa text | Aa text | Aa text | Aa text | Aa text | Aa text | # number | % percent | Aa text | $ currency | $ currency | $ currency | % percent | Aa text |
| WBS-1 | Phase 1 | Task: Discovery | Liam Brown | 2025-01-01 | 2025-01-06 | 5 | 10% | Not Started | $1,500.00 | $300.00 | $1,200.00 | 20.0% | |
| WBS-2 | Phase 1 | Task: Design | Olivia Hernandez | 2025-01-05 | 2025-01-11 | 6 | 17% | In Progress | $2,700.00 | $783.00 | $1,917.00 | 29.0% | |
| WBS-3 | Phase 1 | Task: Build | Noah Moore | 2025-01-09 | 2025-01-16 | 7 | 24% | Done | $3,900.00 | $1,482.00 | $2,418.00 | 38.0% | |
| WBS-4 | Phase 1 | Task: Test | Emma Harris | 2025-01-13 | 2025-01-21 | 8 | 31% | At Risk | $5,100.00 | $2,397.00 | $2,703.00 | 47.0% | WBS-1 |
| WBS-5 | Phase 1 | Task: Launch | Oliver Johnson | 2025-01-17 | 2025-01-26 | 9 | 38% | Blocked | $6,300.00 | $3,528.00 | $2,772.00 | 56.0% | WBS-2 |
| WBS-6 | Phase 2 | Task: Review | Ava Rodriguez | 2025-01-21 | 2025-01-31 | 10 | 45% | Not Started | $7,500.00 | $4,875.00 | $2,625.00 | 65.0% | WBS-3 |
| WBS-7 | Phase 2 | Task: Optimize | Elijah Thomas | 2025-01-25 | 2025-02-05 | 11 | 52% | In Progress | $8,700.00 | $6,438.00 | $2,262.00 | 74.0% | WBS-4 |
| WBS-8 | Phase 2 | Task: Discovery | Sophia Thompson | 2025-01-29 | 2025-02-10 | 12 | 59% | Done | $9,900.00 | $8,217.00 | $1,683.00 | 83.0% | WBS-5 |
+ 14 more rows included in the download
Who it's for
Entrepreneurs, freelancers, small businesses, and teams who need gantt chart excel template.
How to use it
Open in Excel or Google Sheets, fill in your data in the input cells, and the formulas calculate results automatically.
Built-in formulas
- Duration — =NETWORKDAYS(E2,F2) — Working days between start/end
- Spend % — =K2/J2 — Burn rate vs budget
- Variance — =J2-K2 — Budget remaining
- At Risk Count — =COUNTIF(I:I,"At Risk")+COUNTIF(I:I,"Blocked") — Risk indicator
- Project EAC — =SUM(K:K)/(SUM(H:H)/COUNTA(H:H)) — Estimate at completion
- Critical Path Days — =MAX(F:F)-MIN(E:E) — End-to-end span
Make this yours in seconds
Open in our AI chat to customize columns, formulas, and sample data.