Google Sheets has no Gantt chart type, but you can build one in a few minutes. The quickest methods are a stacked bar chart with an invisible first series, a conditional formatting grid, or a single SPARKLINE formula per row. Here is each method, step by step, and when to use which.
Set up your task table
All three methods start from the same table. Put it in columns A to E, starting at row 2:
| A: Task | B: Start | C: End | D: Start day | E: Duration |
|---|---|---|---|---|
| Kickoff | 3/2/2026 | 3/2/2026 | =B2-$B$2 | =C2-B2+1 |
| Research | 3/3/2026 | 3/5/2026 | 1 | 3 |
| Design | 3/6/2026 | 3/10/2026 | 4 | 5 |
| Build | 3/11/2026 | 3/16/2026 | 9 | 6 |
| Launch | 3/17/2026 | 3/17/2026 | 15 | 1 |
Column D counts days from the project start, and column E is the length of each task. Fill both formulas down to the last row.
Method 1: stacked bar chart
- Select columns A, D and E (hold Ctrl or Cmd to select non-adjacent columns).
- Go to Insert → Chart. In the chart editor, under Setup, choose Stacked bar chart.
- Open Customize → Series, select the Start day series and set Fill opacity to 0%. The bars now float at the right place.
- Pick a colour for the Duration series, remove the legend and add a chart title.
Good for: a picture to paste into a slide or a report. Not so good for: dates on the axis, which show as day numbers, and dependencies, which don’t exist.
Method 2: conditional formatting grid
- In
G1, type=$B$2. InH1, type=G1+1and fill right for as many days as the project lasts. - Format row 1 as a short date (Format → Number → Custom date) and narrow the columns.
- Select the grid, from
G2to the last cell, and open Format → Conditional formatting. - Choose Custom formula is and enter
=AND(G$1>=$B2, G$1<=$C2). Pick a fill colour.
Each cell lights up when its date falls inside the task. Change a start or end date and the bar moves. Add a second rule with =G$1=TODAY() and a red border to get a today line.
Method 3: one SPARKLINE formula per row
This is the neatest trick. In F2, paste:
=SPARKLINE({D2, E2}, {"charttype","bar"; "color1","white"; "color2","#5E6AD2"; "max", MAX($D$2:$D$6)+MAX($E$2:$E$6)})
Fill it down and widen column F. Each row now shows a bar that starts on the right day and has the right length: white for the offset, blue for the task. It takes ten seconds, stays inside the table and updates as you type. Adjust the $D$2:$E$6 ranges to your last row.
Which method should you use?
| Stacked bar chart | Conditional formatting | SPARKLINE | Ganttmint online | |
|---|---|---|---|---|
| Setup time | 5 min | 10 min | 1 min | None |
| Real dates on the timeline | No | Yes | No | Yes |
| Today line | No | Yes | No | Yes |
| Dependencies | No | No | No | Yes, drag to link |
| Kanban view | No | No | No | Yes |
Use a ready-made template
Don’t want to build it? Download our free Gantt chart template, upload the .xlsx file to Google Drive and open it with Google Sheets: the formulas and the bars keep working. Planning a single day by the hour, such as an event or a shoot? Use the hourly Gantt chart template instead. And if you also work in Excel, the steps are close to our guide on how to make a Gantt chart in Excel.
The limits of a Google Sheets Gantt chart
Spreadsheets are great for lists, less so for schedules. When a task slips, nothing else moves with it, so you update every date by hand. Sharing a sheet also means sharing every cell, which invites accidental edits. Once a project has more than a handful of dependent tasks, an online Gantt tool saves time: in Ganttmint you drag a bar and the linked tasks follow, then export to Excel or CSV when someone asks for the spreadsheet. The same tasks also open as a Kanban board.
Questions
Does Google Sheets have a Gantt chart?
There is no Gantt chart type in the chart editor, but you can build one with a stacked bar chart, conditional formatting or the SPARKLINE function. Some Google Workspace plans also offer a timeline view.
Is there a free Gantt chart template for Google Sheets?
Yes. Download our free .xlsx template and open it with Google Sheets: the formulas and bars work the same way.
How do I show dependencies in a Google Sheets Gantt chart?
Sheets cannot draw arrows between bars. You can calculate a start date from the end of the previous task, or use an online Gantt tool that links tasks for you.
How do I add a today line?
In a conditional formatting grid, add a rule with the custom formula =G$1=TODAY() and a red border or fill.
Can I import a Google Sheet into Ganttmint?
Yes. Download the sheet as .xlsx or .csv with task, start and end columns, then import it into Ganttmint to get a Gantt chart.