A1:Q15fxAND COUNTA IF MAX MIN SUM
Gantt Chart — the first rows of the actual spreadsheet
Gantt Chart
The opening rows of the file you get — sample data included, not a mock-up.

Projects template

Gantt Chart

12-week bars that draw themselves from a start week and a duration.

$19one payment, yours to keep
  • ✓Instant download
  • ✓Every later version free
  • ✓Commercial use
  • ✓No signup, no watermark
96
live formulas, each one recalculated and checked
17
columns: Task, Owner, Start wk, Weeks, End wk, W1, W2, W3, W4, W5, W6, W7, W8, W9, W10, W11, W12
5
figures worked out for you

A project manager reporting upwards · Agencies, construction and in-house project teams — usually looking for this when someone senior has asked to see the plan on one page.

Need more than one? All 9 Projects templates for $39 — $114 bought separately. All 66 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print landscape on one page wide. Version 1, updated 25 September 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 96 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No email wall, no signup, no watermark, and you can use it commercially.

About this Gantt Chart template

A Gantt chart shows who is doing what and when across the life of a project. This Excel Gantt chart template draws a bar for each task across 12 weeks from just two numbers: the start week and how many weeks the task takes.

Change either number and the bar redraws itself — no dragging shapes around. The plan summary shows the number of tasks, total effort in task-weeks and how long the project runs.

Good for

  • →Planning a project of up to 12 weeks
  • →Showing a client or manager the timeline at a glance
  • →Spotting where tasks overlap and people are stretched

What it works out for you

Plan

  • →Tasks
  • →Total effort (task-weeks)
  • →First week
  • →Last week
  • →Project length (weeks)

What is inside the Gantt Chart template

The table has 17 columns. Calculated columns fill themselves in; the rest are yours to type over.

  • →Task
  • →Owner
  • →Start wk
  • →Weeks
  • →End wk
  • →W1
  • →W2
  • →W3
  • →W4
  • →W5
  • →W6
  • →W7
  • →W8
  • →W9
  • →W10
  • →W11
  • →W12

How to use the Gantt Chart in Excel

Set a start week and a duration; the bar fills itself. Change either and the chart redraws — no dragging shapes around.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

ANDCOUNTAIFMAXMINSUM

Questions about the Gantt Chart

How are the bars drawn?

Each week cell checks whether that week falls between the task's start and end week, and the bar is shaded wherever it does.

Can I plan more than 12 weeks?

The template is set up for 12 weeks. You can add weeks by copying the last week column, with its formula and formatting, across.

Does it show dependencies between tasks?

No. It shows timing only. Set start weeks so a dependent task begins after the one it relies on.

What you get with the Gantt Chart

  • ✓96 formulas, every one recalculated and checked
  • ✓Opens with sample rows already filled in
  • ✓Excel, Google Sheets and LibreOffice Calc
  • ✓Set up to print landscape, one page wide
  • ✓Commercial use, no attribution needed
  • ✓Every later version included free

Get the Gantt Chart for $19

One payment. The file downloads straight away, and every later version of it is yours at no extra cost.

Buying a few? All 9 Projects templates for $39, or all 66 for $99.

More projects templates

See all Projects →