Can You Make a Gantt Chart in Google Sheets?

Yes. You can make a Gantt chart in Google Sheets by arranging tasks against a row of calendar dates, then using conditional formatting to color the cells that fall within each task’s start and end dates. For a chart-style version, you can also use a stacked bar chart; the date-grid method is usually simpler to build and update.

What a Google Sheets Gantt chart can show

A Gantt chart displays project tasks as horizontal bars across a timeline. Each bar indicates when a task starts and finishes, so you can see the project schedule at a glance. In Sheets, the underlying information is usually a task list with start dates and durations or end dates. The visual layer is either a colored calendar grid or a chart built from those values.

A basic chart can show task names, dates, and overlaps. You can add columns for owners, milestones, status, or dependencies, too. However, Sheets does not automatically manage a project plan just because the cells look like a Gantt chart: changing a predecessor task will not automatically reschedule dependent work unless you build that logic yourself.

For example, a small website project might include writing, design, development, and review. If design runs from June 3 through June 7 while writing runs from June 1 through June 5, the overlapping bars make it easy to see that the work happens in parallel.

Choose a layout before building

Decide how much detail the timeline needs before formatting it. A daily grid is easy to understand for a short project, but it becomes very wide over several months. Weekly columns are more compact for longer plans, though they show less precise start and finish dates.

Use a daily grid for short projects, event planning, or schedules where exact dates matter.
Use a weekly or monthly view when the plan spans many weeks and the exact day is less important.
Use a stacked bar chart if you want a conventional chart with task labels and a date axis rather than a cell-based calendar.

It also helps to agree on what a duration means. In the example below, a task lasting three days includes its start date and its end date. That means a task starting June 1 ends June 3, not June 4. If your team counts working days only, you will need a different approach to account for weekends and holidays.

Set up the task table and timeline

Create a new sheet with columns for Task, Start, Duration (days), and End. Put the first task on row 2, with its start date in B2 and its duration in C2. Add a date row across the sheet beginning in F1; each column after that represents the next calendar day. Keep the date values as actual dates, not text that merely looks like a date.

For a task beginning June 1, 2026 and lasting three calendar days, enter the start date and duration in the task row. With the start date in B2 and the number of inclusive calendar days in C2, enter =B2+C2-1 in D2. The result is June 3, 2026. Copy the formula down the End column for the other tasks. If you prefer to enter end dates by hand, you can skip the Duration column and use the start and end dates directly.

Enter the first day of the timeline in F1. With F1 holding the first date and G1 as the next timeline cell, enter =F1+1 in G1, then drag or copy it to the right. The result is the calendar date one day after F1. Format the header cells as dates using Format > Number, and choose a date format that stays readable across narrow columns. Freeze the task columns or the header row if the sheet is large, so labels remain visible while you scroll.

Color the task bars with conditional formatting

Conditional formatting turns the timeline grid into the bars. Select the cells where task rows cross calendar dates, such as F2:AJ20 for 19 task rows and 31 timeline columns. Open Format > Conditional formatting. In the panel, set the rule to Custom formula is, then enter the formula below. It checks whether the date at the top of each column falls on or between the task’s start and end dates.

With start dates in column B, end dates in column D, date headers in row 1, and the selected range starting at F2, use =AND(F$1>=$B2,F$1<=$D2) as the custom formula. Choose a fill color and click Done. The dollar signs keep the date-header row and date columns fixed as the rule is applied across the range, while the task row changes for each line. If your columns differ, adjust the references to match your layout.

Now each task’s dates should appear as a colored horizontal bar. If no cells are colored, check that the start and end entries are recognized as dates, that the rule’s apply-to range includes the timeline cells, and that the formula refers to the first cell in that selected range. You can use a different color for another category by adding a separate rule, but keep the visual system restrained so the schedule remains legible.

Add useful project details

A Gantt view is most useful when it helps answer practical questions, not just show colored blocks. Keep task names concise and put extra information in separate columns. An owner column, a status dropdown, and a notes column can make the sheet useful as a shared project tracker without crowding the timeline.

Mark milestones: Add a Milestone task with the same start and end date, or use a distinct symbol or formatting rule so it is not mistaken for a multi-day task.
Show progress: Add a percent-complete field and update it manually, or use a separate progress indicator. The date bar alone does not indicate how much work is finished.
Separate planned and actual dates: Keep actual dates in their own columns if you need to compare performance against the original schedule.
Include a legend: Explain colors for status or work type. Do not rely on color alone if collaborators may have difficulty distinguishing the shades.

For a simple status system, use labels such as Not started, In progress, and Complete. A task that is scheduled to run through Friday may still be incomplete on Friday, so make clear whether the bar represents planned dates, actual work, or both.

Use a stacked bar chart instead

A stacked bar chart is another way to make a Gantt-style display. The usual setup uses a hidden or visually minimized first series for the time from a common project start to each task’s start, followed by a duration series for the task itself. The offset series pushes each visible duration bar to the correct position on the timeline. Task names provide the labels.

To try it, prepare columns for task name, start-date offset, and duration, select the data, and choose Insert > Chart. In the Chart editor, select a stacked bar chart. The exact chart styling may need adjustment: hide or de-emphasize the offset series, set the axis to cover the project dates, and make sure task names are readable. Unlike the conditional-formatting grid, a chart is a separate object and may take more tuning to keep its date scale and labels clear.

The chart method is worth considering when you want a more presentation-ready graphic or a compact view of many tasks. The grid is often easier when collaborators need to inspect individual dates, edit the schedule directly, or apply familiar spreadsheet filters. Neither method automatically creates dependency management.

Limitations, common problems, and accuracy

Sheets is flexible, but a hand-built Gantt has limits. A daily timeline can become unwieldy as the project grows. A bar shows a planned time span, not workload, cost, or task completion unless those details are represented separately. Dependencies, resource conflicts, and automatic rescheduling generally require additional formulas or manual updates.

Watch for these common issues:

Dates are text: A typed value that Sheets cannot parse as a date may not compare correctly in a conditional-formatting rule. Re-enter it in a recognized date format or use Format > Number to check the cell format.
Duration counting is inconsistent: Decide whether the start day counts. The formula shown here treats a three-day task as June 1, June 2, and June 3.
The timeline does not cover a task: Extend the date headers and the conditional-formatting range far enough to include all project dates.
Weekends look like workdays: The basic setup counts calendar days. To show only workdays, you need to build a business-day schedule and handle holidays explicitly; do not treat the basic duration formula as a working-day calculator.
Bars appear on the wrong rows: Check that the custom formula’s row reference matches the first selected task row and that the start and end columns are correct.

For schedules where weekends and holidays matter, decide whether bars should visually span nonworking days even when no work is planned. Some teams keep calendar spans and shade weekends; others calculate working-day end dates. Those are different conventions, so label the schedule clearly rather than assuming every viewer will interpret it the same way.

Sharing, cost, and when to use another tool

Google Sheets is useful when people need to edit the same plan, add notes, or view a schedule from a browser. Sharing controls let the owner choose who can view, comment, or edit, so confirm access settings before sending a project sheet beyond its intended audience. Avoid putting sensitive project or personal information in a broadly shared file.

Sheets is available without a separate spreadsheet purchase for many personal Google account uses; organizations may use Google Workspace plans with their own pricing and terms. Check Google’s current plan details for your account rather than assuming every business feature is included at no cost.

For a small project, a spreadsheet may be all you need. Consider dedicated project-management software if the plan requires automatic dependencies, workload balancing, baselines, notifications, resource allocation, or portfolio reporting. Microsoft Excel can also create Gantt-style schedules with conditional formatting or charts, but its menus and collaboration setup differ from Google Sheets. Choose based on the scheduling features and collaboration workflow you actually need, not only on the appearance of the chart.

Frequently Asked Questions

Does Google Sheets have a built-in Gantt chart?
Sheets does not offer a dedicated project-planning Gantt tool that automatically manages tasks and dependencies. You can create the visual with conditional formatting or build a Gantt-style stacked bar chart, and templates may also be available to adapt.

What is the easiest way to make a Gantt chart in Google Sheets?
For most small schedules, use a task table with start and end dates, place calendar dates across the top, and apply a custom conditional-formatting rule to the task-date grid. It is direct to edit and does not require chart-axis adjustments.

Can Google Sheets show task dependencies?
You can add a predecessor column and record relationships, but the basic Gantt setup will not automatically move a task when its predecessor changes. Automatic rescheduling requires additional formulas or a project-management tool with dependency features.

Can I make a weekly Gantt chart instead of a daily one?
Yes. Put week-start dates in the timeline header and use a consistent rule for assigning tasks to weeks. A weekly view is narrower, but tasks that begin or end midweek will be shown less precisely than in a daily grid.

Can multiple people edit a Google Sheets Gantt chart?
Yes, if the file owner shares it with the appropriate access level. Collaborators can edit the task data and formatting according to their permissions, but agree on who maintains formulas and formatting rules to reduce accidental changes.

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.