Google Sheets has no chart type called Gantt. You can get one three ways: the built-in timeline view (on some Google Workspace editions), a stacked bar chart with the first series hidden, or conditional formatting that colours a grid of date cells.
All three start from the same table: a task name, a start date and either an end date or a duration. Download the template below to skip the typing.
Free download
- Download the CSV template Phase, Task, Owner, Start, Duration (days), End and Progress columns with an example plan. In Google Sheets choose File, Import, Upload.
Method 1: the timeline view
The quickest option, if your account has it. Google's help page lists timeline view for Google Workspace business, enterprise, education and frontline editions and doesn't mention personal Google accounts.
- Set up the columns. Make one row per task with a task name, a start date and an end date (or a duration). The dates must be real dates, not text, and each start must be earlier than its end.
- Insert the timeline. Choose Insert, then Timeline. Select the data range or accept the suggested one, then click OK. Sheets opens the timeline on a new tab.
- Pick the card fields. In the timeline settings, choose the start date, end date (or duration) and card title columns. Choose a column such as Phase or Owner to group the rows.
- Colour the cards. Pick a column as the card colour source. Google's help page notes that conditional formatting on the source data stops you changing card colours, so keep the source table plain.
Method 2: a stacked bar chart
This works on any Google account and gives you a chart you can paste into Docs or Slides.
- Add a helper column "Start day" with =B2-MIN($B$2:$B$50) where column B holds the start dates. It turns each start date into days from the project start.
- Select the task names, the Start day column and the Duration column, then choose Insert, Chart and set the chart type to Stacked bar chart.
- In Customize, Series, pick the Start day series and set its fill opacity to 0%. The invisible first bar pushes each visible bar to its start.
- If the first task sits at the bottom, sort the table the other way or reverse the axis order in the chart's axis settings.
Method 3: conditional formatting on a date grid
This draws the chart in the cells themselves, so it prints and updates with the table. Put task names in column A, start dates in B and end dates in C, then dates across row 1 from column E (one column per day or per week). Select the grid, for example E2:BZ50, choose Format, Conditional formatting, Custom formula is, and enter:
=AND(E$1>=$B2, E$1<=$C2)Method 3, continued: weekly columns and a today line
With one column per week, colour a cell when the week overlaps the task instead, and add a second rule with a border colour for the current week:
=AND(E$1<=$C2, E$1+6>=$B2)
=AND(TODAY()>=E$1, TODAY()<E$1+7)What Sheets can't do for you
- Dependencies. Google's timeline help page describes cards with dates, grouping and colour, not links between tasks, so moving one task doesn't move the next. In a plain sheet you can chain tasks with a formula such as =C2+1 for the next start date.
- Critical path. You work out which chain of tasks sets the finish date by hand.
- Milestones. A zero-length task shows as a one-day card or cell; mark it with a colour of its own.
Moving the plan into a Gantt chart tool
Copy the rows from your sheet, including the header row, and paste them into the box on the gantt-chart.io homepage. A column whose header contains "Task" becomes the task name and a column whose header contains "Duration" or "Days" becomes the length. Each row becomes a bar, linked one after another, up to 80 rows, with no account needed.
To keep the start dates, owners and phases too, download the sheet as CSV (File, Download, Comma-separated values), sign in free and open the editor's Import data panel. It reads columns named Task, Start, End or Duration (days), Owner, Phase and Progress, which are the template's column names.
Frequently asked questions
- Does Google Sheets have a Gantt chart?
- Not as a chart type. Some Google Workspace editions have a timeline view (Insert, Timeline) that shows tasks as cards on dates. On any account you can build one with a stacked bar chart or with conditional formatting.
- Can a Google Sheets Gantt chart show dependencies?
- Not as linked bars. You can make the next task's start date a formula of the previous task's end date, so a change flows down the list, but there are no arrows and no critical path.
- Is the template free?
- Yes. The CSV template is a free download with no sign-up. It opens in Google Sheets, Excel or any spreadsheet app.
- How do I turn my Google Sheets plan into a Gantt chart with dependencies?
- Copy the rows, header included, and paste them on the gantt-chart.io homepage, or download the sheet as CSV and import it after signing in free. Then link the tasks in the editor and the critical path is calculated for you.
Sources
Related
Try it on your own plan
Paste a task list on the homepage and get a live Gantt chart with dependencies and a critical path. No account needed to try.