Guide

How to Make a Gantt Chart in Google Sheets

Two easy ways to build a project timeline in Google Sheets, a quick conditional formatting grid or a stacked bar chart, with step-by-step instructions.

Updated November 19, 2026In Spreadsheets

A Gantt chart shows project tasks as horizontal bars on a timeline, so you can see what happens when and how tasks overlap. You do not need special software. Google Sheets can do it in two ways.

Prefer a ready-made version? Download our Gantt chart template and open it in Google Sheets.

Method 1: Conditional formatting grid (easiest)

This method colors cells automatically between each task’s start and end dates.

Step 1: Set up your task list

Create columns for Task (A), Start date (B) and End date (C). Enter one task per row, starting in row 2.

Step 2: Add date columns across the top

In cell E1, enter your project start date. In F1, enter =E1+1 and drag it across for as many days as your project lasts. Use =E1+7 instead for a weekly timeline. Format the row as dates (Format › Number › Custom date and time, for example M/d).

Step 3: Add conditional formatting

  1. Select the grid area, for example E2:AH20.
  2. Go to Format › Conditional formatting.
  3. Under “Format cells if…”, choose Custom formula is.
  4. Enter: =AND(E$1>=$B2, E$1<=$C2)
  5. Choose a fill color and click Done.

The cells between each task’s start and end dates now fill with color. Change any date and the bar moves automatically.

Step 4: Add a “today” marker (optional)

Add a second rule with the formula =E$1=TODAY() and a different color to highlight today’s column.

Method 2: Stacked bar chart

This method creates a proper chart object you can copy into slides.

Step 1: Prepare your data

Task Start date Days from project start Duration (days)
Planning 3/1/2027 =B2-$B$2 7
Design 3/8/2027 =B3-$B$2 10
Build 3/18/2027 =B4-$B$2 14
Launch 4/1/2027 =B5-$B$2 2

Step 2: Insert a stacked bar chart

  1. Select the Task, Days from project start and Duration columns (hold Ctrl or Cmd to select non-adjacent columns).
  2. Click Insert › Chart.
  3. In the Chart editor, set Chart type to Stacked bar chart.

Step 3: Hide the first series

  1. In the Chart editor, go to Customize › Series.
  2. Select the Days from project start series.
  3. Set Fill opacity to 0%.

The invisible bars push the visible bars to the right starting position, creating a Gantt chart.

Step 4: Tidy up

  • Under Customize › Vertical axis, tick Reverse axis order so the first task appears at the top.
  • Add a chart title and adjust colors.

Tips for project timelines in Sheets

  • Link dependent tasks with formulas, for example =C2+1 for a start date the day after the previous task ends.
  • Add an “Owner” column and a “% complete” column for status tracking.
  • Freeze the task columns (View › Freeze) so they stay visible as you scroll across dates.
  • Share with “Comment” access so stakeholders can leave feedback without changing dates.

For the bigger picture, document scope, milestones and owners in a project plan.

Frequently asked questions

Does Google Sheets have a built-in Gantt chart?

Google Sheets has a Timeline view (Insert › Timeline) that displays tasks with start and end dates as bars, which works much like a simple Gantt chart. It is available on many Google Workspace plans. The two methods in this guide work in any version of Google Sheets.

Can a Google Sheets Gantt chart show dependencies?

Not automatically. You can add a "Depends on" column and set start dates with formulas, such as =C3+1 to start the day after a previous task ends, so dates shift when earlier tasks change.

Is a Google Sheets Gantt chart good for big projects?

It is great for small and medium projects with up to a few dozen tasks. For large projects with many dependencies and resources, dedicated project management software is usually better.

Related templates and guides