Create a Free Gantt Chart in Google Sheets: Steps and Tips

Yes. You can create a free Gantt chart in Google Sheets by listing tasks and their start and end dates, building a row of calendar dates, and using conditional formatting to color the cells that fall within each task’s date range. The chart updates as you change dates, and you do not need a paid add-on for this basic approach.

What a Google Sheets Gantt chart shows

A Gantt chart places project tasks down the left side and time across the top. A colored bar on each task’s row represents the period when that work is scheduled. This makes it easier to see how long tasks take, where work overlaps, and when a project is expected to start or finish.

Google Sheets is a practical option for a small project, a personal plan, or a schedule shared with a few collaborators. It is a spreadsheet-based chart rather than a dedicated project-management system: you control the task list, dates, and colors, but features such as automatic dependency scheduling and resource leveling are not built into this simple layout.

The method below uses a grid and conditional formatting, rather than relying on a particular chart template. It works in Google Sheets in a web browser and can be adapted as the schedule changes.

Set up the task table

Open a blank Google Sheet and make a table with one task per row. Use columns A through F for the task details, for example:

A: Task name
B: Owner or team member
C: Start date
D: End date
E: Duration in calendar days
F: Status, such as Not started, In progress, or Done

Put column headings in row 1 and the first task in row 2. Enter dates as actual spreadsheet dates, not text that merely looks like a date. If a value is left-aligned or does not sort chronologically, check its format. You can select the date cells and choose Format > Number > Date.

Decide whether your end dates are inclusive. For a typical project plan, an activity running from Monday through Wednesday occupies three calendar days, so the chart should color Monday, Tuesday, and Wednesday. The duration formula below uses that inclusive convention. If your organization defines end dates differently, keep the chart and duration rules consistent.

Calculate task duration

With the task’s start date in C2 and end date in D2, enter this formula in E2:

=D2-C2+1

For example, if C2 is February 2, 2026, and D2 is February 4, 2026, the result is 3 calendar days. The calculation includes both the start and end date. Copy the formula down the duration column for the remaining tasks.

This counts weekends as well as weekdays. That is appropriate when a task occupies calendar time, such as a waiting period or a delivery window. For work measured in business days, use a separate business-day calculation and decide how holidays should be treated; a simple calendar-day duration may otherwise overstate working time. Also check that each end date is on or after its start date, since reversed dates produce a misleading duration.

Build the timeline across the sheet

Choose where the calendar should begin. If the task table uses columns A through F, use G1 for the first timeline date. With task start dates in C2:C20, enter this formula in G1:

=MIN($C$2:$C$20)

This returns the earliest start date in that range. It assumes every task in the range has a valid start date; if the table includes empty rows, check that the minimum is still the date you intend to display. You can also type a chosen project start date directly into G1 instead.

In H1, enter the following formula, then drag the fill handle to the right to create consecutive days:

=G1+1

Each cell advances the timeline by one day. Select the header cells and use Format > Number > Date, or choose a compact date format so the columns remain narrow. If a project spans several months, showing every day can make the sheet very wide. You can use weekly or monthly planning columns instead, but the bar formula must then match the time unit and the way you define each period.

Color the task bars with conditional formatting

Select the area where bars should appear, such as G2:AZ20. The range should cover the timeline columns and all task rows, and the timeline header should be directly above the task rows. Choose Format > Conditional formatting. In the side panel, set the rule to Custom formula is and enter:

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

Choose a fill color and select Done. Google Sheets evaluates the rule for every cell in the selected range. G$1 keeps the header row fixed while the column changes across the calendar; $C2 and $D2 keep the date columns fixed while the task row changes. In effect, a cell is colored when its column’s date is on or after that task’s start date and on or before its end date.

For a task starting February 2 and ending February 4, the cells under those three dates are colored and adjacent dates are not. If the bars appear on the wrong rows or shift by a day, check that your selected range starts at G2, that the formula refers to the header in row 1, and that the dates in columns C and D are real dates.

Make the schedule easier to read

A usable chart needs more than colored bars. Freeze the task headings or identifying columns so they stay visible while you scroll. In Google Sheets, use View > Freeze to choose the rows or columns to keep in place. Widen the task-name column, use a consistent date format, and keep the timeline cells narrow enough to show a useful span without making the sheet difficult to navigate.

Use a clear header row and distinguish it from task rows with bold text or a fill color.
Keep the bar color consistent for ordinary scheduled work. If you add a second status color, explain what it means in a small legend.
Sort or group related tasks in a way that helps readers follow the project, such as planning, delivery, and review.
Consider a separate milestone row for a single-day event, such as a launch or approval. Give it the same start and end date so the conditional-formatting rule colors one day.
Use notes or a separate column for details that would make task names too long.

For example, a website project might include “Draft page copy” from February 2–6, “Build page layout” from February 5–12, and “Review and approve” from February 13–16. The first two bars overlap, making it visible that layout work begins before all copy is finished. That overlap may be intentional, but the chart itself does not decide whether the plan is realistic.

Keep dates, dependencies, and progress accurate

A Gantt chart displays the dates you enter; it does not automatically move a task when another task changes. If “Build page layout” must wait until “Draft page copy” is complete, update the layout start date yourself when the copy schedule shifts, or use a separate dependency column to record the relationship. The conditional-formatting rule only colors dates between the start and end values.

Progress also needs a clear definition. A status column is often more useful than changing the bar’s dates to imply completion. For a basic chart, you can keep the scheduled bar in one color and write the status in column F. If you use different colors for completed and active work, make the meaning explicit and apply separate rules carefully so they do not obscure one another.

Review the chart when a date changes, a task is added, or the project range expands. If new tasks extend below row 20, extend the conditional-formatting range; if the schedule runs past column AZ, extend the timeline and formatting range to the right. A formula or rule limited to the original range will not cover new rows or dates automatically.

Common problems and fixes

No bars appear: Confirm that the conditional-formatting rule is set to Custom formula is, the selected range starts at G2, and the formula references the correct start and end columns.
Bars start one day late or end early: Check that the end date is treated as inclusive and that the formula uses both greater-than-or-equal-to and less-than-or-equal-to comparisons.
Dates display as numbers: Select the affected cells and use Format > Number > Date. Spreadsheet dates are stored as serial values, so an unformatted date can look like an ordinary number.
The timeline starts too early: Inspect all dates included in the MIN range. An unintended old date in the task list can pull the first timeline date backward.
New tasks have no bars: Extend the conditional-formatting range to include their rows and make sure the timeline covers their dates.
The sheet is too wide: Display fewer days by planning at a weekly or monthly level, or split a long project into phases on separate tabs.

Conditional formatting changes cell appearance, not the underlying dates. Copying or exporting the sheet may preserve the formatting, but always check that the recipient can read the date headings and understand the color key.

Google Sheets versus Excel and project tools

The core layout can also be recreated in Excel: a task table, date columns, and a conditional-formatting formula are not exclusive to Google Sheets. The menu names and sharing workflow differ, however, and an Excel workbook may need a compatible format if collaborators edit it in Sheets. In Google Sheets, the relevant conditional-formatting menu is Format > Conditional formatting; follow the menu paths for the specific program you are using rather than assuming that every interface is identical.

Sheets is a good fit when people need an accessible, editable schedule and the project has a manageable number of tasks. A dedicated project-management tool may be a better choice when you need automatic dependencies, multiple project views, workload planning, notifications, or reporting across many projects. Those tools may have free plans, paid tiers, or feature limits that change over time, so check current plan details before choosing one. A spreadsheet is not automatically inferior; it simply requires more manual upkeep as the project becomes more complex.

Cost and sharing considerations

You can build this basic chart in Google Sheets without paying for an add-on. Access to Google Sheets is available through Google accounts, although the account or organization you use may determine which services and sharing controls are available. The core chart depends on ordinary cells, formulas, and conditional formatting, rather than a paid charting extension.

To collaborate, use the Share button and choose who can view, comment on, or edit the file. Give edit access only to people who need to change the schedule. If a project contains sensitive information, follow your organization’s sharing and retention policies; a chart being easy to share does not mean its contents should be public. A copy of the sheet can also be useful before making major structural changes.

Frequently Asked Questions

Can I make a Gantt chart in Google Sheets for free?
Yes. A task table, date formulas, and conditional formatting are enough to create a basic Gantt chart without a paid add-on. Your account’s available services and sharing settings can still depend on whether it is personal or managed by an organization.

Does Google Sheets have a Gantt chart template?
You may find project-planning templates in the template gallery, but the available choices can change. The grid method in this guide does not depend on a particular template and lets you control the columns, dates, and formatting.

How do I show weekends in a Google Sheets Gantt chart?
The daily timeline includes weekends unless you omit those dates or use a different time scale. To make weekends easier to identify, format the relevant date columns separately or create a calendar that displays only working days, taking care that the date comparisons still match the dates in your task table.

Can the bars move automatically when a task changes?
The bars redraw automatically when you edit a task’s start or end date because the conditional-formatting rule reads those cells. Other tasks do not automatically reschedule based on dependencies in this basic setup; you must revise their dates yourself.

Can I use this chart for project milestones?
Yes. Enter the same date as both the start and end date for a one-day milestone. The rule colors the single matching timeline cell, which you can explain in a legend or label in the task-name column.

When this method is the right fit

A Google Sheets Gantt chart is a useful free starting point when you want a visual schedule that collaborators can inspect and edit, and you are comfortable maintaining dates manually. Set up the task table, create a timeline that covers the project, and use conditional formatting to draw the bars. For a short project, that may be all you need. As dependencies, reporting, and workload coordination grow more important, compare the time spent maintaining the sheet with the features of a dedicated project tool.

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.