How to Create a Gantt Chart in Google Sheets

To create a Gantt chart in Google Sheets, list each task with its start and finish dates, add a row of calendar dates across the sheet, then use conditional formatting to color the cells that fall within each task’s date range. This creates a flexible, spreadsheet-based timeline that updates when you change task dates.

What a Gantt chart shows

A Gantt chart is a schedule displayed as horizontal bars across a calendar. Each row represents a task, and the bar shows when that task starts and finishes. Unlike a simple task list, the visual timeline makes it easier to see which work overlaps, what is coming up, and where the schedule has gaps.

Google Sheets does not have a dedicated, one-click Gantt chart type. A common approach is to build the timeline in a grid and use conditional formatting to color the cells between each task’s start and end dates. This method is easy to adapt, works directly with dates, and does not require a separate chart object. It is most suitable for small and medium-sized project schedules, rather than detailed project-management work with complex resource leveling or dependency calculations.

Set up the task table

Open a blank Google Sheet and create columns for the task name, start date, finish date, and duration. Put the timeline dates in the same header row, starting in column E. For example, the first row could use A1 for Task, B1 for Start, C1 for Finish, and D1 for Duration; cells E1 onward will hold dates.

Enter one task per row, beginning in row 2. Use actual spreadsheet dates in the Start and Finish columns, not text that merely looks like a date. Format the date columns with Format > Number > Date if needed. A short sample might look like this:

Research: start June 1, finish June 4
Draft: start June 3, finish June 8
Review: start June 9, finish June 10

These example tasks overlap: drafting begins before research ends. That is normal in many schedules, and the chart will show the overlap clearly. Choose whether your finish dates are inclusive. The method below treats both the start and finish dates as workdays on the calendar, so a task running June 1 through June 4 occupies four daily cells.

Add duration and calendar dates

Duration is optional, but it helps readers understand the amount of calendar time assigned to each task. With start dates in B2:B50 and finish dates in C2:C50, enter this in D2 to count both endpoints:

=C2-B2+1

For example, a task starting June 1 and finishing June 4 returns 4. Copy the formula down the Duration column for the other task rows. If you want duration to mean elapsed days excluding the finish date, omit the +1; be consistent about the choice in your schedule.

Enter the project’s first timeline date in E1. With E1 holding the first date and the next calendar date needed in F1, use this formula in F1:

=E1+1

Drag the fill handle to the right to extend the timeline for as many days as the project needs. Format the header cells as dates. If the sheet covers many months, use a narrow column width and a compact date format such as day and month. Keep the underlying cell values as dates so the conditional formatting can compare them correctly.

For a weekly timeline, you can instead advance the date by seven days. With E1 containing the first week’s date and F1 as the next header cell, use =E1+7 in F1 and fill right. Weekly cells are useful for a long project overview, but a task that starts or ends midweek will appear at week-level granularity rather than on its exact day.

Color the schedule with conditional formatting

Select the timeline area where bars should appear, such as E2:AI50. Open Format > Conditional formatting. In the conditional-formatting panel, confirm that the apply-to range is E2:AI50, open the “Format cells if” menu, and choose “Custom formula is.” With task names in column A, start dates in B, finish dates in C, and the timeline headers in row 1, enter:

=AND($A2<>"",E$1<=$C2,E$1>=$B2)

Choose a fill color and click Done. The formula checks whether the date at the top of a column is on or after the task’s start and on or before its finish. The task-name check keeps blank rows from being colored. The dollar signs matter: they keep the task date columns fixed while the row changes for each task, and keep the header row fixed while the column changes across the timeline.

If the bars do not appear, check the range and references carefully. The rule should start at E2 if its apply-to range starts at E2. If your task table begins elsewhere, adjust the formula to match the top-left cell of the selected range. Also confirm that the dates in B, C, and row 1 are real dates, that each finish date is not earlier than its start date, and that the header timeline includes the task dates.

Make the chart easier to read

A working grid becomes more useful when the schedule is easy to scan. Consider these adjustments:

Format the date headers: Use a short date format and center the labels. For a long schedule, show weekly or monthly labels instead of squeezing every date into a narrow column.
Resize the timeline columns: Make daily cells narrow enough to show a continuous bar while leaving the task names readable.
Freeze the task labels: Use View > Freeze to keep the header row visible while scrolling. Freezing columns can also keep task names in view when moving far across the timeline.
Use separate colors sparingly: A single color for planned work is clear. You can add another conditional-formatting rule for milestones or status, but too many colors can make the schedule harder to interpret.
Mark milestones distinctly: A milestone is usually a zero-duration event. Because the inclusive bar formula expects a date range, represent it with a separate marker column, a symbol, or a dedicated conditional-formatting rule instead of treating it as an ordinary multi-day task.

You can also add columns for owner, status, or dependency. Keep those details outside the date grid so the timeline remains legible. If a task depends on another task, record that relationship explicitly; a bar chart does not automatically understand dependencies or move later tasks when an earlier date changes.

Update dates and manage schedule changes

The main advantage of this layout is that the colored bars recalculate when you edit a start or finish date. If a task moves from June 3–8 to June 5–10, change its dates in the task table; the conditional-formatting rule will color the new span. If the project’s first date changes, update E1 and fill the timeline dates right again, or make sure the existing header range still covers all task dates.

When adding more tasks, extend the conditional-formatting apply-to range to include the new rows. For example, a rule covering E2:AI50 will not color task 51 unless you expand the range. Similarly, extend the timeline farther right if a revised finish date falls beyond the last header cell. These two limits—the number of task rows and the width of the calendar—are common reasons a chart appears to stop updating.

For shared schedules, decide who can edit dates and who should only view the sheet. Google Sheets’ sharing controls let you grant access as an editor, commenter, or viewer. Before distributing a project plan, check that collaborators understand the date convention, especially whether finish dates are inclusive and whether the schedule uses calendar days or working days.

Common limitations and troubleshooting

This grid-based chart represents calendar days unless you build extra logic to exclude weekends or holidays. A task that runs Friday through Monday will fill all four calendar dates, including Saturday and Sunday. If the plan is based on working days, consider hiding or visually distinguishing weekend columns, or use a more specialized schedule design. Do not assume the basic formula automatically skips non-working days.

Other common issues include dates stored as text, mismatched regional date formats, and an incorrect conditional-formatting range. If a value such as 6/1 is interpreted differently under a collaborator’s locale, use an unambiguous date entry and confirm the displayed date. If every cell is colored, verify that the formula references the correct columns and uses the header row. If no cells are colored, check that the header dates and task dates overlap and that the task-name column is populated.

Google Sheets is collaborative and convenient, but a spreadsheet Gantt chart does not provide every feature found in dedicated project-management software. It will not automatically balance workloads, enforce task dependencies, or send schedule alerts based on the colored bars. Those functions require additional setup or a different tool.

Google Sheets compared with other options

Google Sheets works well when a team needs a shareable timeline, wants to customize the layout, or already tracks project details in spreadsheets. Multiple collaborators can update the same document, and the chart is built from ordinary cells and formatting. It is also easy to copy the schedule into another sheet or print a simplified view.

Excel can create a similar grid-based Gantt chart with conditional formatting, but its menus and collaboration environment differ from Google Sheets. Google Sheets instructions such as Format > Conditional formatting apply to the Sheets interface in a web browser, not Excel. Dedicated project tools may be a better fit when a project needs linked task dependencies, workload views, baseline tracking, or automated notifications. Choose based on the complexity of the work and how the team will maintain the schedule, rather than on the appearance of the chart alone.

Frequently Asked Questions

Does Google Sheets have a built-in Gantt chart template?

Google Sheets may offer templates through its template gallery, but it does not provide a dedicated Gantt chart type in the standard chart editor. A common approach is to use a date grid and conditional formatting, or adapt an available project-plan template to suit your schedule.

Can I make a Gantt chart in Google Sheets automatically update?

Yes. When the conditional-formatting rule is based on each task’s start and finish dates, changing those dates changes the colored bar automatically. The rule’s apply-to range must include the task row, and the date headers must cover the revised dates.

How do I show weekends in a Google Sheets Gantt chart?

The basic daily timeline includes weekends because it treats each date as a calendar day. You can leave weekends visible, shade their columns with a separate formatting rule, or design a working-day schedule that excludes them. The basic bar formula does not skip weekends by itself.

Can I add task dependencies to the chart?

You can add a dependency column to record which task must happen first, but the basic conditional-formatting chart will not automatically move dependent tasks when dates change. You must update the dates yourself or build additional spreadsheet logic for the scheduling rules you need.

Why are my Gantt chart bars not showing?

Check that the start, finish, and header values are actual dates; the header range includes the task’s dates; and the conditional-formatting range begins where the formula expects. Also verify that the finish date is on or after the start date and that the task row has a name.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.