Gantt Chart for Google Sheets: Setup, Uses, and Limits

Yes. You can make a Gantt chart in Google Sheets by putting tasks and dates in a table, then using conditional formatting to shade the calendar cells between each task’s start and end date. Google Sheets also offers a Timeline view for date-based plans; the best choice depends on whether you need a quick visual schedule or a chart you can customize closely.

What a Gantt chart shows

A Gantt chart lays project tasks out against a calendar. Each task appears as a horizontal bar: its position marks when work starts, and its length represents how long it is planned to take. A chart can also show milestones, groups of work, owners, or progress, but those details depend on how the sheet is designed.

The basic information is simple: a task name, a start date, and an end date. For example, a small website project might include “Write page copy” from April 3 to April 7, “Build page” from April 8 to April 12, and “Review” from April 11 to April 14. The overlap makes it clear that review begins before the build task has finished.

A Gantt chart is a planning aid, not proof that a project will finish on time. It makes timing and overlap easier to see, but it cannot automatically account for every dependency, staffing constraint, or unexpected delay unless you add and maintain that information.

Choose a Sheets approach

There are three useful ways to show a schedule in Sheets, and they suit different needs:

Conditional-formatting calendar: A grid with tasks down the side and dates across the top. Rules color the cells that fall within each task’s date range. It is easy to understand and works well for a small or medium plan.
Stacked bar chart: A chart uses an invisible or background-colored offset series followed by a duration series. It resembles a conventional Gantt chart, but takes more chart setup and can be less convenient to edit as a calendar.
Timeline view: Sheets’ Timeline view presents date-based records on a movable timeline. It is useful for browsing and grouping tasks, although its availability and options can depend on your Google account or Workspace edition.

For a first project schedule, the colored calendar grid is usually the clearest starting point. Choose Timeline view if you want to explore or group date-based records without building a calendar grid. Use a stacked bar chart when a chart object is important for a presentation or report.

Prepare the task and date data

Start with one row per task. A practical table might use column A for the task, B for the start date, C for the end date, D for the owner, and E for status. Keep dates in date format rather than typing labels such as “next Monday”; Sheets needs actual date values to compare dates reliably. Use Format > Number > Date if a value is displaying in an unexpected format.

Check that each end date is on or after its start date, and decide whether your schedule counts both the first and last day. For a daily project plan, inclusive dates are often intuitive: April 3 through April 7 covers five calendar days. For a plan measured in working days, weekends need separate treatment; a basic calendar grid will otherwise show Saturday and Sunday just like any other date.

Then make a row of date headings to the right of the task data. Put the first date in the first heading cell and continue across the sheet at the interval you need. Daily headings show detail but can create a very wide sheet. Weekly headings are more compact, though a task that starts or ends midweek will be shown less precisely. Keep the heading cells as dates, even if you format them to display a shorter label.

Build a calendar with conditional formatting

Enter task names in A2:A20, start dates in B2:B20, and end dates in C2:C20. Adjust the row range to match your task list.
Put real date values in the heading row, beginning in E1, and fill the dates across the columns. Leave columns A through D for task information if you want to include an owner or status.
Select the calendar area, such as E2:AZ20, and choose Format > Conditional formatting.
In the conditional-formatting panel, select the option for a custom formula and enter the rule below. Choose a fill color and select Done.

With dates in E1:AZ1, task start dates in B2:B20, task end dates in C2:C20, and the rule applied to E2:AZ20, use =AND(E$1>=$B2,E$1<=$C2). For a task running April 3 through April 7, the rule is true for calendar headings on those dates and colors the matching cells. The dollar signs keep the heading row and date columns fixed appropriately as Sheets evaluates the rule across the selected grid.

To make the result readable, freeze the task columns or heading row when the sheet is wide or long. In Google Sheets, use View > Freeze and choose the rows or columns to keep visible. You can also format the heading row with a contrasting fill, widen the task-name column, and apply borders sparingly so the schedule remains legible.

Calculate duration and make a chart

A duration column is useful for checking the schedule or preparing a stacked bar chart. Put a label such as Duration in D1. With start dates in B2:B20 and end dates in C2:C20, enter =C2-B2+1 in D2 and fill it down. For a task starting April 3 and ending April 7, the result is 5 calendar days because this calculation counts both endpoints. If your plan uses elapsed time rather than inclusive calendar days, the appropriate calculation may differ.

For a stacked bar chart, create an offset column as well as the duration column. With start dates in B2:B20 and the earliest project date in that range, enter =B2-MIN($B$2:$B$20) in a separate offset column on row 2 and fill it down. The earliest-starting task returns 0; a task starting three days later returns 3. The offset creates empty space before each duration bar, positioning bars along the project timeline.

Select the task names, offset values, and durations, then choose Insert > Chart. In the Chart editor, select a stacked bar chart and check that the task names are used as labels and the two numeric columns as series. The offset series is there to position the visible duration, not to look like task work. Set its color to match the chart background if the chart editor options allow; because this is a visual workaround rather than a dedicated Gantt chart type, it may need adjustment when the chart background changes. A conditional-formatting grid is often simpler when you need to inspect individual dates.

Use Sheets Timeline view

For a more interactive schedule, select the task data and choose Insert > Timeline, if the option is available in your account. Sheets will ask you to configure the source data, including the columns used for the card title and start and end dates. You can also set details or grouping fields when your data supports them. The exact choices depend on the columns in the selected range and the feature available to your account.

Timeline view is not simply the same thing as a shaded cell grid. It is a separate way to view date-based records, so changes to the source table and view settings matter. Use clear column headings and consistent dates, and verify the displayed cards against the underlying rows. If you cannot find Timeline in the Insert menu, check that the selected data has suitable date columns and consult your account’s current Sheets feature availability; do not assume a missing menu means the date values are wrong.

Common problems and practical fixes

No cells are colored: Confirm that the conditional-formatting range includes the calendar area and that start and end dates are real dates. Also check that the formula’s row numbers match the first task row in the selected range.
Bars appear one day too short: Decide whether the end date should be included. The duration formula above adds 1 for inclusive counting; the conditional-formatting rule includes both the start and end dates.
The calendar is too wide: Switch from daily to weekly headings, split a long project into phases, or limit the displayed date range. A compact view is easier to scan, but make the chosen interval clear to readers.
Dates look right but do not compare correctly: Some entries may be text rather than dates. Re-enter them as dates or use Format > Number > Date, then check that the cells are recognized as date values.
A task is mistaken for a fixed commitment: Label planned dates as estimates when appropriate, and include an owner or status column. A colored bar communicates a plan; it does not certify that work is complete or guarantee that a deadline is achievable.

For larger projects, decide who can edit the source dates and how changes will be recorded. Sheets supports sharing and simultaneous editing, which is useful for collaboration, but unrestricted edits can also make a schedule confusing. Use Share to set appropriate access, and consider protecting key formula or heading ranges if collaborators should update task details without changing the structure.

Costs, collaboration, and limits

Creating a basic Gantt-style grid does not require a paid project-management add-on: the table, formulas, and conditional formatting are standard Sheets features. Google account and Workspace plans can differ in storage, administrative controls, and feature availability, so check the terms for the account you use rather than assuming every Timeline option is included for everyone. Third-party templates and add-ons may also have their own charges or data permissions.

Sheets is a sensible fit for a lightweight plan, a class assignment, a household project, or a small team that already works in shared spreadsheets. It is less suitable when a project depends on many linked tasks, resource leveling, complex permissions, audit trails, or automated scheduling. A spreadsheet can display dependencies you enter, but the basic colored-grid method does not automatically move downstream dates when one task slips.

Frequently Asked Questions

Does Google Sheets have a built-in Gantt chart?
Sheets does not offer a dedicated chart type named Gantt chart in the standard chart list. You can create a Gantt-style display with conditional formatting or a stacked bar chart, and Timeline view is another date-based option where available.

Is Google Sheets Gantt chart free?
The basic spreadsheet method uses standard Sheets features and does not require a paid Gantt add-on. Timeline availability and other account features can vary, and third-party products may charge fees, so check the details for your account and any add-on before relying on it.

Can Google Sheets automatically update task dates?
A conditional-formatting schedule updates its colored cells when you edit a task’s start or end date. It does not, by itself, calculate task dependencies or automatically shift later tasks. You would need additional formulas or a project-management tool for more advanced scheduling behavior.

How do I show weekends in a Sheets Gantt chart?
A daily date row will show weekends unless you omit those dates or format weekend columns differently. If the plan is based on working days, choose a clear convention and make sure readers know whether durations include weekends.

Can I use a Google Sheets Gantt chart template?
Yes. You can open a template from Google Sheets’ template gallery or use a template shared by someone else, then replace its sample tasks and dates. Before entering sensitive project information, check who can access the file and whether any connected add-on requests additional permissions.

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.