How to Create a Gantt Chart in Google Sheets Step by Step

Project management software is overkill for a five-task plan, but a plain list of tasks and dates tells you nothing about overlap or sequence at a glance. A Gantt chart does — bars laid along a timeline, each task’s length and position visible at once. Google Sheets builds one from an ordinary stacked bar chart, no add-on required, and the whole trick comes down to making one set of bars invisible. This walks the data setup, the duration math, the chart, and the one customization that turns a bar chart into a timeline.

Set up the task data

A Gantt chart needs three things per task: what it is, when it starts, and how long it runs. Lay them out in three columns — task name, start date, end date — and the chart math follows from there.

Use real dates, not text, in the Start and End columns — the chart can only do its math on actual date values. With those three columns in place, the rest is two helper formulas and a chart, and you never touch the raw dates again once they’re entered.

Keep the task list in the order you want them stacked, because the chart follows row order. If tasks run in sequence — design can’t start until research ends — entering them top to bottom in order makes the finished chart read like a staircase, each bar starting near where the previous one ends. The data order becomes the chart order, so a little thought about sequence here saves rearranging the chart later.

Calculate the offset and duration

A stacked bar chart needs two numbers per task: how many days after the project start each task begins (the offset), and how many days it lasts (the duration). Add two helper columns. For the offset in D2 — days from the project’s first date to this task’s start:

=B2-$B$2

Locking $B$2 (the earliest start) means every task measures from the same origin. The first task returns 0; later tasks return how many days in they begin. Duration in E2 is simply end minus start:

=C2-B2

These two columns — offset and duration — are what the chart actually plots. The offset becomes an invisible spacer that pushes each bar to its start position, and the duration becomes the visible bar. Getting these right is the whole foundation; the chart steps after are mechanical.

If you track tasks in days rather than end dates, swap the end-minus-start formula for your own day count — the offset still measures from the project start the same way. Either approach works because the chart only ever sees two numbers per task: where it begins and how long it runs. However you store the dates, reduce them to those two values and everything downstream behaves identically.

Insert a stacked bar chart

Select the task names plus the offset and duration columns — task, offset, duration — and build the chart from them.

1. Select the Task, offset, and duration columns (Ctrl-click to grab non-adjacent ones).
2. Go to Insert → Chart.
3. In the Chart editor, set Chart type to Stacked bar chart.

You’ll get bars where each row shows two stacked segments: the offset first, then the duration. It doesn’t look like a Gantt chart yet — both segments are colored — but the structure is right. Each task’s duration bar is already sitting at the correct distance from the left, pushed there by its offset segment. One more step makes it a timeline.

Make the start bars invisible — the whole trick

The offset segments are spacers, not data you want to see. Hide them and the duration bars float into place as a Gantt chart.

This single move — making the offset series transparent rather than deleting it — is what separates a Gantt chart from a plain bar chart. The invisible bars still occupy their space and still push the visible bars rightward to each task’s start; you just can’t see them. It feels like a hack the first time, and it is exactly how every spreadsheet Gantt chart works under the hood.

If the bars don’t line up after hiding the offset, the usual culprit is the offset formula measuring from the wrong origin. Double-check that $B$2 is locked to the earliest start date with both dollar signs, not a relative reference that shifts per row. When every offset measures from the same fixed origin, each bar lands exactly where its dates say it should — and when one bar is mysteriously too far right, its offset is almost always the reason.

Polish: order, labels, and a progress view

A working Gantt chart usually needs two fixes. Tasks often appear bottom-to-top, reversed from your list — in the Customize tab, the vertical axis has a “Reverse axis order” option that flips them back to reading order. And the default title and legend rarely help, so rename or delete them by clicking directly on each.

1. Open the Customize tab in the Chart editor.
2. Under “Vertical axis,” tick “Reverse axis order” so tasks read top to bottom.
3. Click the title and legend directly to rename or delete them.

For a sense of progress, add a percent-complete column and shade it with a conditional formatting rule beside the chart, or split each duration into “done” and “remaining” segments for an in-bar progress look. On a shared plan, pairing the chart with a collaborative workflow keeps the dates current as the team updates them, and the chart redraws on its own. Google’s own chart editor documentation covers every customization option.

When a spreadsheet Gantt is enough

For a handful of tasks and a timeline you want to see at a glance, this beats dedicated software: it lives next to your data, updates when the dates change, and costs nothing. Set up the three columns, add the offset and duration formulas, build a stacked bar chart, and hide the offset series — four steps to a timeline that maintains itself. When a project grows into dozens of tasks with real dependencies and resource leveling, a dedicated tool earns its place, but for the plans most people actually run, the invisible-bar trick is all the Gantt chart you need. It’s the same build-it-yourself logic behind a live KPI dashboard — your data, visualized, with nothing extra to maintain. Build it once and the timeline redraws itself every time a date moves: research slips two days, its bar slides over, and everything sequenced after it adjusts on its own. That self-updating quality is what makes a spreadsheet Gantt worth the ten minutes of setup over a static drawing you’d have to redo by hand each week.