Gantt Chart Template: Free Auto-Updating Excel & Word + Example

A Gantt chart is a horizontal bar chart that shows a project’s tasks against a timeline: each bar’s position and length show when a task starts, how long it lasts, and how it overlaps with the others. It turns a list of jobs into a picture of the whole project. You can download a free, editable UK template below — an Excel version that draws its own bars from the dates you type, plus a Word version, both with a worked example filled in. No email address required.

Key takeaways

  • A Gantt chart answers one question at a glance: what is happening when. Tasks run down the left; time runs across the top; bars sit where the two meet.
  • The parts that matter: a task list, a start date, an end date, the duration, dependencies (which task waits on which), milestones, percent complete, and a “today” line.
  • Our free Excel template draws the bars itself. Type a start and end date and the coloured bar appears across the right dates on its own — nothing to draw by hand.
  • Excel is free and enough for most small projects. You only need dedicated software once several people are updating the same plan at once.
  • Download the free Excel and Word template below — blank, plus a filled UK small-business example.

What is a Gantt chart?

A Gantt chart is a way of drawing a project so you can see its shape. List your tasks down the left-hand side, lay a calendar across the top, and draw a bar for each task that begins on its start date and ends on its end date. The result is a row of bars, stepping down and across the page, that shows the order of the work, how long each piece takes, and where jobs run at the same time.

It is named after Henry Gantt, an American engineer who popularised the chart in the early twentieth century; the idea has outlived the drawing board and is now the default way to picture a schedule. Its value is that a single glance replaces a paragraph: you can see that the launch slips if photography runs late, or that two people are booked on the same week, without reading a word.

A note on jargon: a task is one unit of work with a start and an end. Duration is how many days or weeks it takes. A dependency is a link that says one task cannot start until another finishes. A milestone is a fixed checkpoint with no duration — a launch date, a sign-off — usually drawn as a diamond. We define the rest as we go.

What does a Gantt chart look like?

Here is a small one. Four tasks for a website relaunch, running July to October, with two milestones marked as diamonds. Read across any row to see when that task happens; read down any week to see what is in flight.

A sample Gantt chart: website relaunch, Jul to OctJulAugSepOctPlan & contentPhotographyBuild siteStaff trainingSoft launchFull launchBars show start, length and overlap; diamonds are milestones (a fixed date, no duration).

What goes in a Gantt chart?

Strip a Gantt chart back and it is a table with a calendar attached. These are the parts worth knowing, in the order you build them.

  1. Task list. Every distinct piece of work, one per row. Keep them at a sensible size — a task you cannot finish in a week or two is usually two tasks.
  2. Start date and end date. When each task begins and finishes. In our template these are the only dates you type; everything else follows.
  3. Duration. How long the task runs. This should be worked out for you (end date minus start date), not typed twice — that is what stops the chart drifting out of step with the dates.
  4. Dependencies. The links between tasks. The common one is finish-to-start: task B cannot begin until task A is finished. Building the site, for instance, waits on the content being ready.
  5. Milestones. Fixed checkpoints with no length — a launch, a board sign-off, a go-live. Drawn as a diamond so they stand out from the bars.
  6. Percent complete. How far each task has got. A quick way to see, in one column, whether the project is on track.
  7. A “today” line. A vertical line on today’s date, so you can see at a glance which bars should be finished by now and are not.

What is a dependency? Finish-to-start in plain English

A dependency is a rule that one task waits on another. The one you will meet most often is finish-to-start: the second task cannot start until the first has finished. You cannot train staff on the new site until the site is built; you cannot build the site until the content is written. Drawn out, dependencies are why the bars step down and to the right rather than all starting on day one.

Finish-to-start: B waits for AA · Write contentB · Build sitefinishesthen startsThree other types exist (start-to-start, finish-to-finish, start-to-finish), but finish-to-start covers most small projects.

For a small project you rarely need to draw the dependency arrows formally. It is enough to order the tasks correctly and set each start date after the task it relies on. The chart then shows the cascade on its own.

How do you make a Gantt chart in Excel?

You can build one from scratch in a few minutes, and it is worth doing once so you understand what the template is doing for you. The trick that matters is the last step: letting conditional formatting draw the bars, so they update themselves when dates change.

  1. Build the task table. In the first columns, list your tasks down the rows with headings for Task, Owner, Start and End.
  2. Make duration a formula, not a number. In a Duration column, type =End-Start (the end cell minus the start cell). Now if a date moves, the duration corrects itself. Typing the number by hand is the single most common reason a homemade Gantt goes wrong.
  3. Lay a calendar across the top. To the right of the table, fill a row of dates or week-numbers running left to right — these are your timeline columns.
  4. Let the bars draw themselves. Select the grid under those date columns and add a conditional-formatting rule with a formula like =AND(D$1>=$C2, D$1<=$D2) — in plain terms, “shade this cell if its column date falls between this task’s start and end”. Choose a fill colour. Excel now paints a bar across exactly the right dates, and re-paints it the moment you change a date.
  5. Add milestones and a today line. Mark fixed dates with a symbol, and add a rule that shades the column matching =TODAY() so you always see where now is.

That conditional-formatting step is the whole craft of an Excel Gantt. Done this way, the chart is not a drawing you maintain — it is a picture the spreadsheet keeps in step with your dates. Our template has all of this set up already, on both the blank and the worked-example tabs, so you can skip straight to typing your own tasks.

A filled example: a UK small business

Most Gantt examples online use a software-rollout at a large firm. Here is one for a real UK situation: a small homeware shop, Wren & Willow (an illustrative example, not a real firm), relaunching its tired website as a proper online shop. The dates and figures are realistic for a business of that size, and they match the worked example in the downloadable template.

TaskOwnerStartEndDuration
Build site & pagesWeb agency01 Jul 202608 Aug 202638 days
Photograph productsAnna14 Jul 202622 Aug 202639 days
Listings & paymentsRavi + agency11 Aug 202605 Sep 202625 days
Train two staffRavi08 Sep 202612 Sep 20264 days
Soft launch (milestone)Ravi15 Sep 202615 Sep 20260 days
Full launch (milestone)Anna01 Oct 202601 Oct 20260 days

Notice the overlaps: photography starts before the site build is finished, and listings begin while photography is still running. A list of dates hides that; the Gantt shows it, and shows that if listings or payments slip, training and the soft launch slip with them. In the downloadable Excel, dates like these draw the bars automatically: type a start and end date and the bar fills the right weeks. The sample chart above is illustrative.

Do you need software, or is a spreadsheet enough?

For a cost-conscious founder this is the real question, and the honest answer is that a spreadsheet is enough far longer than software vendors suggest. Excel (or free Google Sheets) handles a single project with one person keeping it up to date without any trouble. You move to dedicated software when the spreadsheet starts to creak — not before.

Use a spreadsheet when…Consider software when…
One project, one person updating itSeveral people edit the same plan at once
Dependencies are simple (finish-to-start)You need the schedule to re-flow automatically when a task slips
You update it weekly by handYou want live status, alerts and a shared view
Budget matters and the answer needs to be freeYou run many projects and need them in one place

If you do reach for a tool, the established names include Microsoft Project, Smartsheet, monday.com, Asana, TeamGantt and GanttPRO; several have free tiers for one project. We name them so you know where to look — this is not an endorsement of any one, and most small projects never need them. Start with the spreadsheet, and let it tell you when you have outgrown it.

Download the free UK Gantt chart template

Free, editable, no email required. The Excel file draws its own bars: type a start and end date and the coloured bar appears across the right dates by itself, using conditional formatting. Each file includes a blank chart and the filled Wren & Willow example above.

UK date format, designed for small businesses. Made by a practitioner, not a software vendor — there is nothing to sign up for.

A Gantt chart usually lives inside a larger plan. Our project plan template is where the Gantt sits once the project is running; the project charter template authorises the project before any of this starts; and the work breakdown structure template helps you list the tasks in the first place, before you put dates against them.

Frequently asked questions

What is a Gantt chart?

A Gantt chart is a horizontal bar chart that shows a project’s tasks against a timeline. Each bar’s position shows when a task starts and its length shows how long it lasts, so you can see the order of the work and where tasks overlap at a single glance.

How do I make a Gantt chart in Excel?

List your tasks with start and end dates, make a Duration column that calculates end minus start, lay a row of dates across the top, then use conditional formatting to shade each cell whose column date falls between a task’s start and end. That shading is the bar, and it updates itself when you change a date. Our free template has this set up already.

What is the difference between a Gantt chart and a timeline?

A timeline marks events along a single line — useful for milestones and key dates. A Gantt chart adds a row per task and a bar per task, so it shows duration and overlap as well as dates. A timeline says when things happen; a Gantt chart also says how long they take and what runs alongside what.

What are dependencies in a Gantt chart?

A dependency is a link saying one task waits on another. The common type is finish-to-start: the second task cannot begin until the first has finished — for example, you cannot build a site until the content is written. Dependencies are why the bars step down and across the page rather than all starting at once.

What is a milestone?

A milestone is a fixed checkpoint with no duration — a launch date, a sign-off, a go-live. It is usually drawn as a diamond rather than a bar, because it marks a moment rather than a stretch of work. Milestones are how you track the dates that matter most.

Is there a free Gantt chart template?

Yes. The Excel and Word templates on this page are free and need no email address. The Excel version draws its bars automatically from the dates you enter, and both include a filled UK example you can adapt.

What is the difference between a Gantt chart and a project plan?

A project plan is the whole picture — tasks, owners, dependencies, budget and schedule. A Gantt chart is one view of that plan: the schedule drawn as bars against time. The Gantt usually lives inside the project plan rather than replacing it.

This article is general guidance on project scheduling, not formal project-management certification material. The Wren & Willow figures are illustrative. Adapt the template to your own project. Updated 14 June 2026.



Leave a Comment