Guide · 2026-08-31

Can You Make a Gantt Chart in Google Sheets? [2026 Guide]

Project schedules can become confusing quickly. Dates sit in one place, task details in another, and nobody can tell whether a delay affects the final deadline.

That uncertainty gets worse when you need a visual timeline but do not have dedicated project software. You may assume Gantt charts require expensive tools or advanced technical skills.

But here’s the truth: you can make a Gantt chart in Google Sheets using a task table, date formulas, and conditional formatting. You can build a basic version in minutes, then improve it with milestones, progress tracking, owners, and automated dates.

This guide shows you the simplest setup, explains the formulas, highlights common mistakes, and helps you decide when Google Sheets is enough for your project.

How to Make a Gantt Chart in Google Sheets

Yes, you can create a Gantt chart in Google Sheets by combining task details with a calendar grid and conditional formatting. Each row represents a task, while colored cells show when that task starts, continues, and ends.

1. Create the task information table

Open a new Google Sheets workbook and create columns for the information your project needs. A simple structure works well:

Column Purpose
Task The activity your team must complete
Owner The person responsible for the activity
Start Date The planned beginning date
End Date The planned completion date
Duration The number of working or calendar days
Status The current progress state

For example, a website redesign might include tasks such as research, wireframes, visual design, development, testing, and launch preparation.

2. Add a timeline across the top

Choose a blank area to the right of your task columns. In the first timeline cell, enter the project’s starting date.

In the next cell, add a formula that advances the date by one day:

=G$2+1

Copy the formula across the row until you reach the project’s expected finish date. Format those cells as dates so the timeline is easy to read.

For a longer project, you can use weeks instead of days. Enter the first Monday, then use this formula in the next timeline cell:

=G$2+7

3. Apply conditional formatting to the timeline

The timeline becomes a Gantt chart when Google Sheets highlights cells that fall between each task’s start and end dates.

Assume the following layout:

Select the timeline range, such as G3:AZ20. Then open Format, choose Conditional formatting, and select the option for a custom formula.

Use this formula:

=AND(G$2>=$C3,G$2<=$D3)

Choose a fill color and select Done. Google Sheets will now highlight every timeline cell that falls within the task’s planned dates.

4. Add progress or status colors

A single color shows timing, but multiple colors can make the chart more useful. You can create separate rules for planned, active, blocked, and completed tasks.

For completed tasks, use a formula such as:

=AND(G$2>=$C3,G$2<=$D3,$F3="Complete")

For active tasks, use:

=AND(G$2>=$C3,G$2<=$D3,$F3="In Progress")

Assign a different color to each rule. For example, completed work could use green, active work blue, and blocked work red.

5. Calculate duration automatically

You can calculate calendar-day duration with:

=D3-C3+1

The extra +1 counts both the start and end date. Without it, a task running from June 1 through June 3 would appear to last two days instead of three.

To count working days and exclude weekends, use:

=NETWORKDAYS(C3,D3)

To exclude holidays as well, list holiday dates in a separate range and use:

=NETWORKDAYS(C3,D3,$M$2:$M$10)

6. Add milestones

Milestones usually have a single date rather than a multi-day range. Add a milestone column or use the same start and end date.

For example, a launch milestone might have June 28 in both date columns. You can then create a special formatting rule:

=AND(G$2=$C3,$C3=$D3)

Use a diamond-style symbol in the task name, such as ◆ Launch, or apply a strong accent color to make the milestone visible.

7. Freeze labels and adjust the view

Freeze the top rows and left columns so task names remain visible as you move across the timeline.

Reduce the width of timeline columns to create a compact visual bar. Keep task and owner columns wider, because those labels need room to remain readable.

Finally, hide unused columns and rows around the chart. A cleaner layout makes schedule risks easier to spot.

What a Google Sheets Gantt Chart Includes

A useful chart has three layers: task information, calendar timing, and visual status. Leaving out any layer can make the schedule harder to interpret.

Task information

This area explains what each row represents. Include task names, owners, status, priority, and any notes your team needs during planning.

For a small marketing campaign, a row might look like this:

Task Owner Start End Status
Landing page copy Maya July 1 July 4 Complete
Design review Jon July 5 July 7 In Progress
Quality check Priya July 8 July 9 Planned

Calendar timing

The calendar area shows when work is planned. Daily columns provide precision, while weekly columns make long projects easier to scan.

Daily timelines work well for a two-week sprint. Weekly timelines are usually more practical for a six-month rollout.

Visual status

Colors turn rows of dates into a schedule you can understand quickly. Keep the color system small and consistent.

Four colors are often enough:

Add a small legend above or beside the chart. This prevents new contributors from guessing what each color means.

How to Improve the Timeline

A basic chart shows dates. A stronger chart helps you understand progress, dependencies, and potential delays.

Show today’s date

You can highlight the current day with a conditional formatting rule:

=G$2=TODAY()

Apply a border or contrasting fill instead of a heavy color. This keeps today’s marker visible without hiding task bars.

Mark weekends

Weekends can make the timeline look busier than the actual working schedule. Use a formatting rule to shade them lightly:

=WEEKDAY(G$2,2)>5

A pale gray background separates non-working days from planned work.

Highlight overdue tasks

To find unfinished tasks whose end date has passed, use:

=AND($D3<TODAY(),$F3<>"Complete")

Apply this rule to the task information area. It draws attention to schedule risk before you review every timeline bar.

Show percent complete

Add a numeric progress column, such as 0%, 25%, 50%, 75%, or 100%. You can use this value to create a second visual layer.

For example, a task planned from July 1 through July 10 might show a blue bar for the full period, with a darker shade covering the completed portion. Building that effect requires additional conditional formatting rules and careful range selection.

Google Sheets Gantt Chart Example

Imagine you are managing a product launch scheduled for four weeks. Your task list includes research, design, engineering, testing, and release preparation.

Research runs from August 3 to August 6. Design follows from August 7 to August 13. Engineering starts August 10 and ends August 24, creating an overlap.

That overlap matters because engineering can begin before every design task is finished. The chart exposes the relationship immediately, while a plain list may hide it.

Task Start End Potential relationship
Research August 3 August 6 Provides findings for design
Design August 7 August 13 Creates specifications for engineering
Engineering August 10 August 24 Begins while design is finishing
Testing August 25 August 28 Requires an engineering handoff
Release preparation August 29 September 1 Depends on testing results

Here’s why this layout helps: overlapping bars reveal parallel work, gaps reveal idle time, and long bars reveal activities that may need closer planning.

Common Mistakes to Avoid

Using text instead of real dates

If you type “August 3” as plain text, formulas may not recognize it as a date. Enter a valid date value and format it afterward.

Forgetting absolute references

The timeline row should usually use a locked row reference, such as G$2. The task row should remain flexible, such as $C3.

If you write G2 instead, the reference may shift incorrectly when Google Sheets applies the rule to other rows.

Applying formatting to the wrong range

Conditional formatting depends on the selected range. If you select only one row, new tasks may not receive the visual rule.

Select the full expected chart area before creating the formula. You can expand the range later when the project grows.

Making the chart too detailed

A timeline with hundreds of daily columns can become difficult to navigate. Group smaller tasks, use weekly periods, or separate the project into phases.

Ignoring dependencies

Color bars show timing, but they do not automatically explain why one task must wait for another. Add a dependency column or a short note for important handoffs.

When Google Sheets Is the Right Choice

Google Sheets works well for small projects, personal planning, simple campaigns, and teams that need a quick visual schedule.

It is especially practical when several people already collaborate in Google Workspace. You can share access, add comments, and adjust dates without introducing another platform.

For example, a three-person event team planning a two-week conference can often manage its schedule with one well-organized chart.

The limitations become clearer as the project grows. Multiple editors, complex dependencies, recurring work, permission requirements, and detailed reporting can make manual maintenance difficult.

When to Use Dedicated Project Management Software

A dedicated project management platform becomes more useful when the chart must connect with broader delivery work.

Consider another approach when you need:

For instance, changing one engineering milestone in Google Sheets may require you to inspect every later date manually. A project platform can connect those relationships and reduce repeated schedule edits.

The best part? You do not need to abandon simple visual planning. A dedicated platform can still provide timeline views while adding task ownership, workflow controls, and reporting.

Google Sheets Gantt Chart Solution: ONES.com

ONES.com gives teams a unified platform for project management and knowledge management. ONES Project handles project planning and delivery, while ONES Wiki supports shared knowledge management. The products are sold separately.

ONES.com product screenshot

Value Proposition

If your schedule has outgrown manual formulas, ONES Project provides a Jira alternative with timeline planning, sprint management, workflows, reporting, and automation in one project environment.

It can reduce the need to maintain separate planning systems while preserving flexible deployment choices, including on-premise and air-gapped environments.

Core Capabilities

Application Scenarios

Software release planning

A development team can manage epics, stories, sprints, testing activities, and release milestones in one structured workflow. Project leaders can review progress without rebuilding a separate visual schedule.

Approval-heavy marketing campaigns

A marketing team can create stages for drafting, review, legal approval, design, publication, and performance monitoring. Custom fields can identify campaign channels, regions, and responsible owners.

Restricted-network engineering projects

An engineering organization with strict network requirements can use an air-gapped deployment. The team keeps project planning and reporting inside its controlled environment.

Common Challenges and Practical Solutions

The timeline becomes too wide

Problem: Daily columns make a long project difficult to scan, especially on a smaller screen.

Solution: Switch to weekly columns for longer schedules. Keep a detailed daily view only for the active phase.

Dates change frequently

Problem: A delayed task can require several manual date changes across the chart.

Solution: Add dependency notes and review downstream tasks after every major change. For complex relationships, move the workflow into project management software.

People interpret colors differently

Problem: One person may treat blue as active work while another sees it as planned work.

Solution: Add a visible legend and keep the color rules consistent across every project view.

Completed work disappears from attention

Problem: Finished tasks may still use the same color as current work, making progress difficult to judge.

Solution: Use a separate completed status rule and add a progress percentage column.

Too many people edit the chart

Problem: Simultaneous changes can overwrite dates, formulas, or formatting.

Solution: Protect formula areas, limit editing access, and assign one person to maintain the schedule structure.

FAQs

Can I make a Gantt chart in Google Sheets without a template?

Yes. You can build one manually with task columns, start and end dates, a calendar row, and conditional formatting. A template can save setup time, but it is not required. The key formula checks whether each timeline date falls between the task’s start and end dates. Once that rule works, you can add status colors, milestones, and progress tracking.

What formula creates the colored bars?

A common custom formula is =AND(G$2>=$C3,G$2<=$D3). It checks whether the timeline date in the top row is greater than or equal to the task’s start date and less than or equal to its end date. Adjust the cell references to match your own layout before applying the rule.

Can Google Sheets show task dependencies?

Google Sheets can show dependencies through notes, dependency columns, or carefully planned dates. However, it does not provide the same automatic relationship management as dedicated project software. If one task moves, you may need to review and adjust related tasks manually. This is manageable for simple schedules and less practical for complex delivery plans.

Should I use daily or weekly columns?

Use daily columns when the project is short or timing must be precise, such as a two-week sprint. Use weekly columns for longer initiatives, such as a six-month product rollout. You can also create two views: a high-level weekly timeline for leadership and a detailed daily timeline for the active delivery team.

How do I show weekends in a Gantt chart?

You can shade weekends with conditional formatting. If your timeline dates are in row 2, use =WEEKDAY(G$2,2)>5. This identifies Saturday and Sunday because the second argument makes Monday equal to 1 and Sunday equal to 7. Use a light fill so weekends remain visible without overpowering task bars.

Conclusion

Yes, you can create a practical Gantt chart in Google Sheets. Start with task names, owners, start dates, end dates, and a timeline row. Then use conditional formatting to turn date ranges into visual bars.

For a small project, that may be all you need. Add milestones, status colors, working-day formulas, and overdue alerts when your planning needs more detail.

But here’s the truth: manual charts become harder to maintain as dependencies, editors, and reporting needs increase. When schedule changes affect wider delivery workflows, ONES.com and ONES Project offer a more structured path beyond a manually maintained chart.