Free Project Timeline & Gantt Chart Template for Excel (2026)
A project timeline with an auto-generated Gantt chart — enter each task's start date, end date, and progress, and Excel draws the colored bars across weekly columns automatically. No manual bar painting. Ships with an 18-task Q1 launch project across 13 weeks, a status dashboard, 7 milestones, and 6 sample owners. Built with 296 formulas across 6 sheets — zero setup, works offline, no add-ins.
Download the Project Timeline Template
Free .xlsx download — no email required. Opens in Microsoft Excel, Excel Online, Google Sheets, and LibreOffice Calc.
Download project-timeline-2026.xlsxExcel 2007+ compatible · Also works in Google Sheets & LibreOffice
Gantt Chart — the showpiece
The Gantt Chart renders 18 tasks across 13 weekly columns for Q1 2026. Each cell has one tiny formula that checks: does this week overlap the task's date range? If yes, draw a bar. Bar color is driven by task Status via conditional formatting.
| # | Task | Owner | % | JAN 2026 | FEB 2026 | MAR 2026 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 12 | 19 | 26 | 2 | 9 | 16 | 23 | 2 | 9 | 16 | 23 | 30 | ||||
| 1 | Project kickoff | Emma | 100% | █ | ||||||||||||
| 2 | Market research | James | 100% | █ | █ | |||||||||||
| 3 | Competitive analysis | James | 100% | █ | █ | |||||||||||
| 4 | Design system audit | Sofia | 100% | █ | █ | █ | ||||||||||
| 5 | Content strategy | Emma | 100% | █ | █ | |||||||||||
| 6 | Homepage wireframes | Sofia | 60% | █ | █ | █ | ||||||||||
| 7 | Template landing pages | Sofia | 25% | █ | █ | █ | █ | |||||||||
| 8 | Add-in MVP scope | David | 100% | █ | █ | █ | ||||||||||
| 9 | Add-in backend dev | David | 15% | █ | █ | █ | █ | █ | █ | █ | ||||||
| 10 | Add-in frontend dev | David | 0% | █ | █ | █ | █ | █ | █ | |||||||
| 11 | Marketing plan | Michael | 40% | █ | █ | █ | ||||||||||
| 12 | SEO strategy exec. | Michael | 0% | █ | █ | █ | █ | |||||||||
| 13 | Copy for 10 pages | Emma | 0% | █ | █ | █ | █ | |||||||||
| 14 | QA testing — Add-in | Aisha | 0% | █ | █ | █ | ||||||||||
| 15 | Beta user onboarding | Aisha | 0% | █ | █ | |||||||||||
| 16 | AppSource submission | David | 0% | █ | █ | |||||||||||
| 17 | Launch prep | Emma | 0% | █ | ||||||||||||
| 18 | Q1 launch milestone | Emma | 0% | █ | ||||||||||||
Every bar cell is one tiny formula: =IF(AND(WeekStart+6>=TaskStart, WeekStart<=TaskEnd), "█", ""). If the week overlaps the task's date range, draw a bar; otherwise leave blank. Conditional formatting colors each bar based on the task's Status.
Project Dashboard — team health at a glance
Five headline KPIs, tasks-by-status, tasks-by-priority, and per-owner workload — all pulled from the Task List via COUNTIF, AVERAGEIF, and SUMIF. Change any progress % and every tile follows.
| Status | Count | % of Total | Avg Progress |
|---|---|---|---|
| Done | 6 | 33.3% | 100% |
| In Progress | 4 | 22.2% | 35% |
| At Risk | 1 | 5.6% | 0% |
| Overdue | 0 | 0.0% | 0% |
| Not Started | 7 | 38.9% | 0% |
| Priority | Count | % Compl. |
|---|---|---|
| High | 15 | 40% |
| Medium | 3 | 47% |
| Low | 0 | 0% |
| Owner | Tasks | Avg Progress | Total Days |
|---|---|---|---|
| Emma Thompson | 5 | 40% | 37 |
| David Kim | 4 | 29% | 86 |
| Sofia Rodriguez | 3 | 62% | 42 |
| Michael Chen | 2 | 20% | 35 |
| Aisha Patel | 2 | 0% | 25 |
| James Wilson | 2 | 100% | 20 |
| TOTAL | 18 | 41% | 245 |
Milestone Tracker — the seven markers that matter
Milestones are the point-in-time markers that separate one project phase from the next. Zero-duration events with a target date, owner, and status. Use them for weekly status updates and stakeholder reviews.
| M# | Target Date | Milestone | Status | Owner |
|---|---|---|---|---|
| M1 | Jan 5, 2026 | Project Kickoff | Done | Emma Thompson |
| M2 | Jan 23, 2026 | Research Phase Complete | Done | James Wilson |
| M3 | Feb 20, 2026 | Design Phase Complete | In Progress | Sofia Rodriguez |
| M4 | Mar 6, 2026 | Content Complete | Not Started | Emma Thompson |
| M5 | Mar 20, 2026 | Add-in Feature Complete | Not Started | David Kim |
| M6 | Mar 27, 2026 | Beta Complete | Not Started | Aisha Patel |
| M7 | Mar 30, 2026 | Public Launch | Not Started | Emma Thompson |
Grab the free Gantt Template — no strings.
Ready-to-use .xlsx · 6 sheets · 296 formulas · Auto-drawn bars · Dashboard KPIs · Milestone tracker.
What's inside — 6 sheets
Six sheets, one clean flow: define tasks, watch bars appear, roll status up to a dashboard.
01Setup Guide
Welcome, 5-step quick start, task-status legend (6 codes: Not Started / In Progress / At Risk / Overdue / Done / On Hold), color legend.
02Project Dashboard
5 KPI tiles + Tasks by Status + Tasks by Priority + Owner Workload + Milestone Status. All rollups via COUNTIF, AVERAGEIF, SUMIF.
03Gantt Chart
THE showpiece. 18 tasks × 13 weekly columns = 234 formula-driven bar cells. Auto-color by Status via conditional formatting + INDEX(TaskStatus, ROW()).
04Task List
18 tasks with Owner dropdown, Start/End dates, auto NETWORKDAYS Duration, Progress % with green data bar, Status/Priority dropdowns, Predecessor, Notes.
05Team Roster
6 sample team members (Emma, David, Sofia, Michael, Aisha, James) with department, role, and Employee ID.
06Milestone Tracker
7 pre-loaded milestones with target date, name, status, owner, notes. Great for weekly status meetings.
Features
What separates this from every "Gantt chart" template that makes you paint the bars by hand.
Auto-drawn Gantt bars
Change any task's start or end date and bars redraw. Cells become blank when the week no longer overlaps. Zero manual painting.
Status-driven color
Conditional formatting colors each bar based on that task's Status: green Done, blue In Progress, amber At Risk, red Overdue, grey Not Started.
Real-time dashboard
5 KPIs + status/priority/owner breakdowns. Add a task or update progress; every tile follows via named-range references.
Milestone tracker
Separate sheet for zero-duration project markers. Use for weekly stand-ups, stakeholder reviews, and go/no-go decisions.
Business-day duration
NETWORKDAYS handles weekends automatically. A 2-week task starting Monday runs through Friday of week 2, not Sunday.
Works everywhere
Excel 365, 2021, 2019, 2016, 2013, 2010, 2007. Google Sheets. Excel Online. LibreOffice Calc. No add-ins.
Who this is for
Built for teams too small for Asana or Jira but too structured for a shared doc with a table.
Small-team PMs
You run 3–8 people through a quarterly launch or a client engagement. You want visual status without a $15/user/month SaaS bill.
Founders & solo operators
You're building a product on the side or with one collaborator. The Gantt shows what you've committed to and what's slipping.
Agency & consultant leads
You run client engagements with defined phases. The milestone tracker + Gantt is the perfect artifact for client status calls.
The Gantt chart — where it came from
Named after Henry Gantt, but built on ideas by others. A quick tour of one of the most durable business visualizations ever invented.
Henry Gantt (1861–1919) & the modern format
American mechanical engineer Henry Gantt popularized the chart format around 1910–1915 while consulting on WWI shipbuilding programs. He wasn't the first — Polish engineer Karol Adamiecki built a nearly identical "harmonogram" in 1896 — but Gantt's version, published widely in English, became the standard.
The chart's genius was collapsing three dimensions into one visual: what is being done (rows), when (horizontal position of the bar), and for how long (bar length). One glance answered questions that had required tables and paragraphs.
Gantt charts were adopted for the Hoover Dam (1931), the Interstate Highway System (1950s), and the Apollo program (1960s). They remain the default project-timeline visualization more than a century later — pretty rare for a business tool.
What a Gantt is good at (and what it isn't)
- Good at: showing planned vs. actual schedule, communicating status to non-PMs, identifying overlap and conflicts, spotting the critical path once dependencies are added.
- Not great at: capturing dependencies richly (arrows help but clutter fast), resource allocation across many people, iterative/agile work with continuous re-planning, projects longer than ~6 months (bar granularity gets awkward).
For projects with heavy dependency logic, tools like MS Project or Primavera add PERT and critical-path analysis. For agile/iterative work, a Kanban board tends to fit better. For most one-off small-to-medium projects, a Gantt in Excel is still the right answer.
Critical Path Method (CPM) & PERT estimation
Two techniques from the 1950s that turn a Gantt chart into a scheduling tool with predictive power.
Critical Path Method
CPM identifies the longest sequence of dependent tasks through your project — the path that determines the earliest possible project end date. Tasks on the critical path have zero slack; any delay pushes the whole project back. Tasks off the critical path have "float" and can slip without hurting the deadline.
Practical application: focus your risk-management effort on critical-path tasks. A one-week delay in a low-float task means someone loses a week; a one-week delay in a critical-path task means the whole project ships a week late.
This template doesn't compute CPM automatically (that requires dependency graph analysis beyond Excel formulas), but the Predecessor column on the Task List lets you document the graph. Add a "Float" column and compute it manually with the formula above.
PERT estimation — the three-point technique
Program Evaluation and Review Technique (PERT) was developed for the US Navy's Polaris submarine program in 1958. It replaces single-point time estimates ("this will take 5 days") with three-point estimates that acknowledge uncertainty.
Example: A task might take 3 days if everything goes perfectly, 5 days in the normal case, or 12 days if things go badly.
- PERT estimate = (3 + 4×5 + 12) / 6 = 5.83 days
- Standard deviation = (12 − 3) / 6 = 1.5 days
- 90% confidence range: roughly 3.4 to 8.3 days
To use PERT in this template: add three columns (Opt / ML / Pess) after the Start date, then a PERT Days column with the formula above. Use the PERT result to compute End Date = Start + PERT days.
Four dependency types — how tasks connect
When Task B "depends on" Task A, there are actually four different relationships PMs distinguish. Getting the type right matters when you're compressing a schedule.
Task B can't start until Task A finishes
The default, most common relationship. "Design signoff must complete before development starts." 90%+ of dependencies are FS.
Task B can't start until Task A starts
Parallel work with a shared trigger. "QA testing starts when Development starts" — they run alongside each other, but testing needs dev code to exist first.
Task B can't finish until Task A finishes
Coordinated finish. "Documentation must complete alongside development" — they both wrap up together, often at a release deadline.
Task B can't finish until Task A starts
Rare and confusing. Handoff scenarios like "The night shift can't leave until the day shift starts." Almost never used in software projects.
Leads and lags
You can add a lead (negative offset) or lag (positive offset) to any dependency. A 3-day lag on an FS dependency means "Task B starts 3 days AFTER Task A finishes" — useful for cure time on paint, review buffers, procurement wait, etc. A 5-day lead on an FS means "Task B can start 5 days BEFORE Task A finishes" — used to fast-track dependent work.
This template's Predecessor column captures the graph as a simple list ("1", "2,3", "5,6"). For rich lead/lag modeling, graduate to MS Project or a dedicated PM tool.
Waterfall vs. agile — where a Gantt fits
A Gantt chart is a waterfall artifact by default: a fixed plan drawn once with milestones distributed across a linear timeline. Agile methodology explicitly rejects that plan-then-execute model. So does a Gantt still work?
| Approach | Planning style | Gantt useful? |
|---|---|---|
| Waterfall | Full plan up front, execute sequentially through phases. | Yes — the canonical use case. Every task on the plan. |
| Agile (Scrum) | Rolling sprints of 1–4 weeks. Backlog reprioritized each sprint. | Partially — for milestones and epic-level roadmapping, not for daily task work. |
| Hybrid ("Water-Scrum-Fall") | Waterfall milestones with agile execution within phases. | Yes — Gantt for phases + milestones, Kanban for within-phase work. |
| Kanban | Continuous flow. No fixed timeline. | Rarely — cumulative flow diagrams beat Gantts here. |
The pragmatic answer
Even pure-agile teams end up with Gantt charts when they need to communicate with executives, customers, or vendors on external deadlines. The rise of "product roadmaps" — timeline visualizations of releases and epics — is Gantt in a new hat.
This template works equally well for both use cases. For a strict waterfall project, log every task. For an agile roadmap, log epics or releases as tasks with rough dates — the Gantt still visualizes what's coming up.
WBS, resource leveling & critical chain
Three more PM techniques that turn a raw task list into a real plan.
Work Breakdown Structure (WBS)
Before you draw a Gantt, you need a task list. The Work Breakdown Structure is the technique for producing one: break the project deliverable into progressively smaller pieces until each piece is small enough to estimate reliably (usually 8–80 hours of work).
- Level 1: Project
- Level 2: Major deliverables or phases
- Level 3: Sub-deliverables
- Level 4: Work packages (the atomic tasks that go on your Gantt)
Rule of thumb: the "100% rule" — every parent element must be fully represented by the sum of its children. If your Level-3 work totals 10 weeks, but the Level-2 phase it rolls up to was budgeted for 8 weeks, you've broken the 100% rule and something is wrong.
Resource leveling
Your critical path might say the project can ship in 12 weeks. But if the plan requires David to work 60 hours a week for 3 weeks straight, it's not actually shippable. Resource leveling adjusts task dates so no person or resource is over-allocated at any point.
On this template, the Owner Workload table on the Dashboard totals days per person. If someone's total days exceed the calendar days available, you're over-allocated. Push tasks or add resources.
Critical Chain Method
Developed by Eliyahu Goldratt in 1997, the Critical Chain Method builds on CPM but factors in resource constraints (not just task dependencies) when finding the longest path. It also adds explicit buffer time at the end of the project (the "project buffer") and before critical-path tasks (the "feeding buffer") instead of embedding buffers inside individual task estimates.
The philosophy: individual buffers get spent by Parkinson's Law ("work expands to fill the time available"), but a shared buffer at project level can absorb overruns without pushing the deadline.
Milestone vs. deliverable — a common confusion
Two words that sound similar, mean different things, and get mixed up by half the PMs on the planet.
| Milestone | Deliverable | |
|---|---|---|
| Duration | Zero — it's a point in time | Non-zero — takes work to produce |
| Example | "Beta released" (a moment) | "Beta release notes doc" (an artifact) |
| On the Gantt | Single vertical marker (or 1-day bar) | Bar spanning the work duration |
| Ownership | Often a PM or exec | Whoever produces the artifact |
Rule of thumb: if it takes time to do, it's a task or deliverable. If it's a specific date when something transitions from "in progress" to "done," it's a milestone. On this template, the last task ("Q1 launch milestone") is technically a milestone — 1-day duration, marking a date. Everything else is a deliverable-producing task.
How to use the template in 5 steps
Zero setup — open the file, start on the Setup Guide sheet, follow the flow.
Update the Team Roster
Replace the 6 sample team members with yours. Every task's Owner dropdown reads from here.
Enter tasks on Task List
One row per task: name, owner (dropdown), Start, End, Progress %, Status (dropdown), Priority, Predecessor, Notes. Duration auto-calcs via NETWORKDAYS.
View the Gantt Chart
The Gantt renders bars automatically — no cell painting. Bar color comes from the task's Status via conditional formatting. Change any date; bars redraw.
Set milestones
On Milestone Tracker: add key project markers with target dates, owners, status, notes. Perfect for weekly status updates.
Watch the Dashboard
5 KPI tiles + status/priority breakdowns + owner workload. Runs off the Task List — no manual updates needed.
Customize it your way
Every formula and layout is open — nothing is protected. Six common edits.
Change the timeline scope
The Gantt uses weekly columns. To shift the window, edit the week header dates on row 6 of the Gantt Chart sheet. To add more weeks, add columns to the right and extend the bar-cell formulas.
Switch to daily columns
Duplicate the Gantt sheet. Change week header cells to daily dates (Jan 5, 6, 7, ...). Update the bar formula from WeekStart+6 overlap check to just Date>=Start, Date<=End.
Add a critical-path column
On Task List, add "On Critical Path" (Yes/No). Manually flag tasks with zero float. Then add conditional formatting on the Task Name column to bold critical-path task names.
Add PERT estimates
Insert columns after Start: Optimistic, Most Likely, Pessimistic. Add a PERT Days column: =(Opt + 4*ML + Pess)/6. Use End Date = Start + PERT Days.
Show % complete on bars
Split each bar cell into two halves: filled (progress×duration) vs. hollow (rest). Change the bar formula to output different characters (█, ▓, ░) based on the progress ratio and the current week's position within the task.
Add sub-tasks / WBS levels
Add a "Level" column and an "Parent ID" column. Use IF and indentation in the Task Name to show hierarchy: =REPT(" ", Level*2) & Task. Group rows via Data ▸ Group.
Stop painting Gantt bars by hand.
Free download · Excel + Google Sheets + LibreOffice · No email · No account · No watermark.
Frequently asked questions
Fourteen questions covering setup, formulas, methodology, and troubleshooting.
Is this Gantt template really free?
Yes. Free for personal and commercial use. Download the .xlsx, use it for as many projects and years as you need, and modify it however you want. No email required, no watermark, no attribution needed.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open with Google Sheets. All 296 formulas convert cleanly because we intentionally use only Excel 2007-compatible functions (IF, AND, COUNTIF, SUMIF, AVERAGEIF, IFERROR, INDEX, MATCH, NETWORKDAYS) — no XLOOKUP, FILTER, or dynamic arrays.
How does the auto Gantt bar drawing work?
Each cell has one formula: =IF(AND(WeekStart+6>=TaskStart, WeekStart<=TaskEnd), "█", ""). It returns a bar character if the week overlaps the task's date range, blank otherwise. Then conditional formatting colors the bars based on the task's Status via INDEX(TaskStatus, ROW()-GanttFirstRow+1). Change any date; bars redraw instantly.
Can I extend the timeline past March 30?
Yes. Add columns to the right of column T on the Gantt Chart sheet. Update the week header row 6 with the new week-start dates. Extend the bar-cell formulas across (they reference the header, so they'll pick up the new dates automatically). Also update the month header spans on row 5.
Can I change to daily instead of weekly columns?
Yes. Duplicate the Gantt sheet. On the duplicate, change the column headers from Monday dates to daily dates (Jan 5, 6, 7, ...). Simplify the bar formula from the week-overlap check to a direct date-in-range check: =IF(AND(Date>=TaskStart, Date<=TaskEnd), "█", ""). You'll need many more columns for the same time span.
How do I add more than 18 tasks?
Add rows to Task List between existing rows. Extend the named ranges (Formulas ▸ Name Manager) if you insert past the current end. On the Gantt Chart sheet, copy an existing task row down — the Row 6 week header references stay stable, the row-anchored $E and $F stay stable. Every dashboard rollup uses named ranges, so no other update needed.
Can I show a "today" line on the Gantt?
Yes with conditional formatting. Add a rule that colors the entire column where the header date equals TODAY(): apply CF to the Gantt range with formula =H$6=TODAY() (where H6 is any column header). Or use =AND(H$6<=TODAY(), H$6+6>=TODAY()) to color the current week's column.
Does this compute the critical path automatically?
No — critical path requires dependency graph analysis beyond what static Excel formulas can do easily. The Predecessor column lets you document the dependency graph. To compute float manually: Float = LateFinish − EarlyFinish. Tasks with zero float are on the critical path. Add a Yes/No "Critical" column and set conditional formatting on the Task Name to bold or highlight critical-path tasks.
Can I add PERT estimates?
Yes. Insert three columns after Start: Optimistic Days, Most Likely Days, Pessimistic Days. Add a PERT Days column: =(Opt + 4*ML + Pess) / 6. Use End = Start + PERT Days − 1. This replaces single-point estimates with three-point estimates and gives you standard-deviation math to feed into risk assessments.
What's the difference between a task and a milestone?
A task has non-zero duration and produces a deliverable. A milestone is a zero-duration marker at a specific date — "Beta launched," "MVP shipped," "Contract signed." Use the Task List for work items and the Milestone Tracker for major markers. The last task in the sample ("Q1 launch milestone") is technically a 1-day milestone; everything else is deliverable work.
Can I show dependencies on the Gantt with arrows?
Not natively in Excel cells — you'd need to draw arrows manually with shapes (Insert ▸ Shapes ▸ Line Arrow). Alternative: use text notation in the Predecessor column ("Depends on 5, 6") and let readers cross-reference. Or graduate to MS Project or dedicated PM software for proper dependency lines.
Why is the Duration column showing 3 instead of 5 for a Monday-to-Friday task?
Check NETWORKDAYS — it counts business days including start and end. Mon–Fri returns 5. If yours shows less, verify the dates and confirm you're not counting weekends as start or end. Also NETWORKDAYS excludes weekends by default; if you need to exclude holidays too, add a third argument with a range of holiday dates.
How do I add resource leveling?
The Dashboard's Owner Workload table shows Total Days per person. Compare to available capacity (workdays in the project window minus PTO). If someone's Total Days exceeds capacity, they're over-allocated. Manually push tasks to resolve. For automated leveling, you'll need Excel Solver or dedicated software.
Do I need Microsoft 365 to open this?
No. This template is built with Excel 2007+ compatibility, which means it opens in Excel 2007, 2010, 2013, 2016, 2019, 2021, 365, Excel for Mac, Excel Online, Google Sheets, and LibreOffice Calc. No subscription required.
Related templates
More free downloads that pair well with the Project Timeline.
Skip the manual scheduling — try the AI Add-in
The Sheets & Cells Add-in identifies your critical path, flags over-allocation, converts single-point estimates to PERT, and drafts weekly status updates for stakeholders — inside Excel, powered by Claude.
Get the AI Add-in →