Free Project Timeline & Gantt Chart Template for Excel (2026) — Auto-Bars, CPM-Ready
TEMPLATE · BUSINESS · PROJECT MANAGEMENT

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

Excel 2007+ compatible · Also works in Google Sheets & LibreOffice

File size26 KB
Format.xlsx
LicenseFree — personal & commercial
Last updatedJanuary 2026
6Sheets included
296Live formulas
18Sample tasks
AUTOGantt bars drawn by formula

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.

project-timeline-2026.xlsx — Gantt Chart
Gantt Chart — Q1 2026 Launch
18 tasks · 13 weeks (Jan 5 – Mar 30, 2026) · 234 formula-driven bar cells
# Task Owner % JAN 2026 FEB 2026 MAR 2026
5121926 291623 29162330
1Project kickoffEmma100% █
2Market researchJames100% ██
3Competitive analysisJames100% ██
4Design system auditSofia100% ███
5Content strategyEmma100% ██
6Homepage wireframesSofia60% ███
7Template landing pagesSofia25% ████
8Add-in MVP scopeDavid100% ███
9Add-in backend devDavid15% ███████
10Add-in frontend devDavid0% ██████
11Marketing planMichael40% ███
12SEO strategy exec.Michael0% ████
13Copy for 10 pagesEmma0% ████
14QA testing — Add-inAisha0% ███
15Beta user onboardingAisha0% ██
16AppSource submissionDavid0% ██
17Launch prepEmma0% █
18Q1 launch milestoneEmma0% █
█Done
█In Progress
█At Risk
█Overdue
█Not Started

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.

project-timeline-2026.xlsx — Project Dashboard
Project Dashboard
Sheets & Cells Q1 2026 Launch · Jan 5 – Mar 30, 2026
Total Tasks18
Avg Progress41%
In Progress4
At Risk1
Done6
Tasks by Status
StatusCount% of TotalAvg Progress
Done633.3%100%
In Progress422.2%35%
At Risk15.6%0%
Overdue00.0%0%
Not Started738.9%0%
Tasks by Priority
PriorityCount% Compl.
High1540%
Medium347%
Low00%
Owner Workload
OwnerTasksAvg ProgressTotal Days
Emma Thompson540%37
David Kim429%86
Sofia Rodriguez362%42
Michael Chen220%35
Aisha Patel20%25
James Wilson2100%20
TOTAL1841%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.

project-timeline-2026.xlsx — Milestone Tracker
M#Target DateMilestoneStatusOwner
M1Jan 5, 2026Project KickoffDoneEmma Thompson
M2Jan 23, 2026Research Phase CompleteDoneJames Wilson
M3Feb 20, 2026Design Phase CompleteIn ProgressSofia Rodriguez
M4Mar 6, 2026Content CompleteNot StartedEmma Thompson
M5Mar 20, 2026Add-in Feature CompleteNot StartedDavid Kim
M6Mar 27, 2026Beta CompleteNot StartedAisha Patel
M7Mar 30, 2026Public LaunchNot StartedEmma Thompson

Grab the free Gantt Template — no strings.

Ready-to-use .xlsx · 6 sheets · 296 formulas · Auto-drawn bars · Dashboard KPIs · Milestone tracker.

Download .xlsx

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.

Total Float = Late Start − Early Start = Late Finish − Early Finish If Total Float = 0, the task is on the critical path.

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.

PERT Estimate = (Optimistic + 4 × Most Likely + Pessimistic) / 6 Standard Deviation ≈ (Pessimistic − Optimistic) / 6

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.

FS — Finish-to-Start

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.

SS — Start-to-Start

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.

FF — Finish-to-Finish

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.

SF — Start-to-Finish

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?
WaterfallFull 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.
KanbanContinuous 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.

MilestoneDeliverable
DurationZero — it's a point in timeNon-zero — takes work to produce
Example"Beta released" (a moment)"Beta release notes doc" (an artifact)
On the GanttSingle vertical marker (or 1-day bar)Bar spanning the work duration
OwnershipOften a PM or execWhoever 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.

1

Update the Team Roster

Replace the 6 sample team members with yours. Every task's Owner dropdown reads from here.

2

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.

3

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.

4

Set milestones

On Milestone Tracker: add key project markers with target dates, owners, status, notes. Perfect for weekly status updates.

5

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.

Functions used in this template

Every formula here is documented on Sheets & Cells — click any function to open its deep-dive guide.

Stop painting Gantt bars by hand.

Free download · Excel + Google Sheets + LibreOffice · No email · No account · No watermark.

Download .xlsx

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.

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 →