How to Insert a Gantt Chart in Google Sheets Step by Step

You can make a Gantt chart in Google Sheets, but Sheets does not provide a dedicated Gantt chart type. The practical options are to build a stacked bar chart from task start offsets and durations, or use a date grid with conditional formatting; some accounts also offer a Timeline view.

What a Gantt Chart in Sheets Can Do

A Gantt chart shows activities as horizontal bars positioned across a time scale. Each row represents a task, and the bar’s position and length indicate when the task starts and how long it lasts. This makes it easier to see the order of work, overlaps, gaps, and the overall project window than a plain task list does.

In Sheets, “insert a Gantt chart” usually means adapting a chart or formatting a range of cells. A stacked bar chart is a chart object you can resize and place on a sheet. A formatted date grid behaves more like a calendar: each day or week is a column, and conditional formatting fills the cells that fall within a task’s dates. Neither method automatically manages dependencies or reschedules tasks when plans change; those details remain in your data and formulas.

Prepare the Task and Date Data

Start with one row per task and clear column headings. A useful source table has Task in column A, Start in B, and Finish in C. Enter actual date values in the date columns, not text that merely looks like a date. Consistent date formatting helps prevent sorting and calculation problems. If a project has many tasks, freeze the header row and keep the task names concise so the chart remains readable.

For the stacked-bar method, add Duration in D and Offset in E. Duration is the number of days the task occupies; Offset is the number of days between the project’s earliest start and the task’s start. Decide whether your schedule counts both the start and finish dates. The example below treats both dates as working calendar days, including weekends; it does not calculate business days.

With task names in A2:A20, start dates in B2:B20, and finish dates in C2:C20, enter this in D2 and fill it down to calculate inclusive calendar-day duration:

=C2-B2+1

For a task running January 5 through January 7, the result is 3 days. With the same source layout, enter this in E2 and fill it down to calculate each start offset from the earliest start in the project:

=B2-MIN($B$2:$B$20)

If the earliest task starts January 5, a task starting January 8 has an offset of 3. The offset is a number of days, not a calendar date. Check that each finish date is on or after its start date, and make sure blank rows are not included in the chart’s data range.

Build the Stacked Bar Chart

A stacked bar chart uses two series for each task: the offset creates an invisible lead-in, and the duration creates the visible bar. Because the chart needs the task labels alongside those two series, create a compact plotting block in three adjacent columns: Task, Offset, and Duration. Copy or link the corresponding task names and calculated values from the source table, including the header row.

Select the plotting block, including its headings.
Choose Insert > Chart. Sheets opens the Chart editor, usually in a panel on the right.
In the editor’s Setup tab, set Chart type to Stacked bar chart. Check that Task is used as the category labels and Offset and Duration are the two series. If the task names appear as bars or the series are wrong, correct the data range or switch rows and columns.
In Customize > Series, select the Offset series and set its color to match the chart background. This conceals the lead-in, leaving the Duration bars visible. If the background is not white, choose a matching background or adjust the chart area so the offset does not show.
Use Customize > Legend to remove the legend if it distracts from the schedule, or keep it if viewers need a key. Give the chart a descriptive title and resize it to show all task labels.

The horizontal scale in this setup represents days from the earliest start, not labeled calendar dates. A bar beginning at offset 3 starts three days after the first project date. That is useful for showing sequence and duration, but viewers may need the source table beside the chart to identify exact dates. If the chart’s first task appears at the bottom, adjust the category-axis ordering in the chart’s customization options if that control is available in your editor.

Create a Calendar-Style Gantt Grid

Use a grid when people need to see actual dates across the top. Put task names in A2:A20, start dates in B2:B20, and finish dates in C2:C20. Enter a sequence of real dates as column headings beginning in G1, with one day per column; format those headings as dates. Select the task-and-date area, such as G2:AK20, and choose Format > Conditional formatting.

In the conditional-formatting panel, choose the option for a custom formula and use a rule based on the date in the column heading and the start and finish dates in that row. With dates in G1:AK1, task rows beginning on row 2, starts in B, and finishes in C, use:

=AND(G$1>=$B2,G$1<=$C2)

Choose a fill color and apply the rule to the full grid range. The dollar signs keep the date headings in row 1 and the schedule dates in columns B and C as the rule moves across and down, while the row number changes for each task. For a weekly view, use a date for each week’s first day as the heading; the rule will mark a week when that heading date is within the task’s dates. If you want a week to be marked whenever any part of it overlaps a task, the rule needs to test the whole week interval instead.

This grid is often easier to read when exact calendar placement matters, and it can be extended with columns for owner, status, or notes. Its trade-off is width: a daily grid for a year needs many columns and may require horizontal scrolling. Freeze the task-name columns, group or hide dates outside the current planning window, and consider a weekly scale for longer projects.

Check for Google Sheets Timeline View

Some Google Sheets accounts include a Timeline view, which can display records with start and end dates on a horizontal timeline. Look under Insert > Timeline if you want to check whether it is available in your account. You need source data with useful labels and date fields, and the editor asks you to identify the relevant columns. Availability and available options can vary by account or Workspace edition, so a missing menu item does not mean your sheet is broken.

Timeline view is not the same as a conventional chart embedded in a cell range. It can be convenient for browsing schedule records, but it does not replace a carefully formatted Gantt chart when you need a particular printed layout or a familiar bar-chart presentation. Keep the underlying table tidy so you can use another display method if the view is unavailable to a collaborator.

Choose the Right Method for Your Project

Choose a stacked bar chart when you want a compact chart object, a quick visual overview, or a presentation-friendly graphic. It is strongest for comparing task durations and relative timing.
Choose a conditional-formatting grid when exact dates, a calendar-like layout, or visible daily or weekly coverage matters more than a compact chart.
Try Timeline view when it appears in your account and its interactive timeline presentation fits the way your team reviews the data.

For example, a small website project might list planning from January 5–7, design from January 8–12, and review from January 10–13. The bar chart makes the overlap between design and review easy to spot. A date grid makes it easier to see which calendar days are occupied. A schedule with owners, milestones, dependencies, and frequent changes may need additional columns or a project-management tool; a basic Gantt display alone does not enforce those relationships.

Common Problems and Fixes

The chart shows dates or enormous bars instead of a useful schedule: Use the calculated day offsets rather than raw date serial values as the offset series. Keep duration as a numeric day count.
The bars start at zero or appear to have no gap: Confirm that the Offset series is included before Duration in the stacked chart, and check that the chart is stacked rather than a regular bar chart.
The offset is visible: Set its series color to the chart background. If the chart background changes, update the offset color as well.
Tasks are missing or misidentified: Check the plotting range, headings, blank rows, and whether Sheets is treating the task column as labels. The chart should have one label and two numeric series per task.
The conditional-formatting grid stays blank: Check that the headings and source values are real dates, that the rule uses the correct columns and row numbers, and that the rule’s apply-to range covers the cells you selected.
The chart is hard to read: Shorten task names, increase chart height, reduce the date window, or choose weekly columns for long schedules. Avoid relying on color alone to communicate status.

Limits, Collaboration, and Maintenance

A Sheets Gantt is only as current as its source data. If a task date changes, the stacked chart’s duration and offset should recalculate from the formulas; a copied plotting block made of static values will not update automatically. Use linked cells or refresh copied values deliberately, and test a date change before sharing the finished schedule. For a grid, the conditional rule updates as long as its source dates and headings stay within the rule’s referenced ranges.

Sheets is useful for lightweight planning and collaboration: people with access can edit the same task table, and you can control sharing through the spreadsheet’s normal sharing settings. But a chart does not automatically calculate critical paths, resolve resource conflicts, notify owners, or protect a schedule from conflicting edits. If a plan depends on those functions, document assumptions and responsibilities in the sheet or consider software built for project scheduling. In Excel, the same general stacked-bar and conditional-formatting approaches are possible, but the chart editor and menu paths differ; the steps above are for Google Sheets in a web browser.

Frequently Asked Questions

Does Google Sheets have a built-in Gantt chart template?
Sheets does not have a dedicated Gantt chart type in the chart picker. You can adapt a stacked bar chart, format a date grid with conditional formatting, or use Timeline view if it is available in your account.

How do I make the first bar start at the project’s start date?
Calculate each task’s offset from the earliest project start, then use that offset as the first series in a stacked bar chart. Hide that series by matching its color to the chart background; the visible duration bar will then sit at the appropriate relative position.

Can a Google Sheets Gantt chart show weekends?
Yes. A daily date grid can include weekend columns, and a calendar-day duration includes them. The basic formulas here do not exclude weekends or holidays; a working-day schedule needs different calculations and clearly defined workdays.

Can I show task progress?
Yes, but progress is not created automatically by the basic setup. Add a Progress column and decide how to display it—for example, with a separate progress series or a status color in a grid. Keep planned dates and reported completion separate so readers do not confuse duration with percent complete.

Why can’t I see Insert > Timeline?
Timeline availability can depend on the account or Workspace edition. If it is absent, use a stacked bar chart or a conditional-formatting grid; both work with ordinary Sheets date and task data.

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.