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
- Select the grid area, for example E2:AH20.
- Go to Format › Conditional formatting.
- Under “Format cells if…”, choose Custom formula is.
- Enter:
=AND(E$1>=$B2, E$1<=$C2) - 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
- Select the Task, Days from project start and Duration columns (hold Ctrl or Cmd to select non-adjacent columns).
- Click Insert › Chart.
- In the Chart editor, set Chart type to Stacked bar chart.
Step 3: Hide the first series
- In the Chart editor, go to Customize › Series.
- Select the Days from project start series.
- 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+1for 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
Gantt Chart Template
A 12-week Gantt chart for planning and tracking project timelines. Shade cells in Excel or on paper to show when each task happens.
TemplateProject Plan Template
Define goals, scope, milestones, tasks and owners for any project in one clear document, from a website launch to an office move.
GuideHow to Copy and Use a Google Sheets Template
How to open any of our Excel templates in Google Sheets, make your own copy, keep the formulas working and share it with others.
RoundupBest Free Google Sheets Templates
Our most useful spreadsheet templates for Google Sheets, from budgets and invoices to project trackers, all free and with the formulas already set up.