How to Make a Simple Gantt Chart in Google Sheets [2026]

Project timelines can become confusing fast. Tasks overlap, deadlines move, and a simple list rarely shows what must happen first. If you need a clear visual plan, learning how to make a simple Gantt chart in Google Sheets can save you hours.

The frustrating part is that Google Sheets does not include a dedicated Gantt chart button. You have to arrange your task dates, build a timeline, and apply conditional formatting manually. A small mistake can leave your bars misaligned or your schedule difficult to update.

Here’s the good news: you can create a practical Gantt chart with a task list, start dates, durations, and one conditional-formatting rule. I’ll walk you through the process, explain common problems, and show when a project platform makes more sense.

How to Make a Simple Gantt Chart in Google Sheets

A simple Gantt chart in Google Sheets uses task names in one column, start dates in another, durations in a third, and calendar dates across the top. Conditional formatting then fills cells that fall within each task’s planned period.

Step 1: Create the project schedule

Open a blank Google Sheets workbook and create these headings in row 1:

• Task
• Start Date
• Duration
• End Date

For example, you might create a small website launch plan like this:

Enter dates consistently. For example, use 6/1/2026 rather than mixing formats such as “June 1,” “01-06-26,” and “1 June.” Consistent dates reduce formatting problems later.

Step 2: Calculate each task’s end date

In cell D2, enter this formula:

=B2+C2-1

Press Enter, then copy the formula down the End Date column. The formula adds the duration to the start date and subtracts one day because the start date counts as the first day.

For example, a task that begins on June 2 and lasts three days ends on June 4. Without the minus one, the formula would show June 5 and make every bar one day too long.

Step 3: Add calendar dates across the top

Choose a row below your project details for the timeline. Row 1 works well if you want the dates beside your headings, while row 5 gives you more room for a project title.

In cell F1, enter the first timeline date. You can use the earliest project start date, such as:

=MIN(B2:B20)

In cell G1, enter:

=F1+1

Drag the formula across enough columns to cover the project. If your schedule lasts 30 days, continue through 30 timeline columns.

Format the timeline row as dates. Select the row, choose Format, select Number, and choose a short date format. You can also use a custom format such as mmm d to show values like “Jun 1.”

Step 4: Apply conditional formatting

Now select the timeline area that matches your task rows. For this example, select F2:AJ20.

Open Format, choose Conditional formatting, and select Custom formula is. Enter this formula:

=AND(F$1>=$B2,F$1<=$D2)

Choose a fill color, such as blue, and click Done. Google Sheets will shade each timeline cell when its date falls between the task’s start date and end date.

Here’s why the dollar signs matter: F$1 keeps the formula connected to the timeline row, while $B2 and $D2 keep the start and end-date columns fixed as the rule moves across the chart.

Step 5: Improve the visual layout

A working chart can still be hard to read. Make a few small adjustments:

• Bold the task names and timeline dates.
• Freeze the top row and first few columns.
• Reduce the width of timeline columns.
• Use a contrasting fill color for weekends.
• Wrap long task names.
• Align dates and durations consistently.

To freeze the task names, choose View, select Freeze, and freeze the columns that contain your task details. When you scroll right, the task names will remain visible.

Step 6: Add a weekend highlight

Weekend shading helps you see the difference between calendar days and working days. Select the same timeline range and create another conditional-formatting rule.

Use this custom formula:

=WEEKDAY(F$1,2)>5

Choose a light gray fill. Keep the weekend color softer than the task-bar color so the schedule remains easy to scan.

If your team works on weekends, skip this rule or adjust it to match your working calendar.

Step 7: Add progress tracking

A basic Gantt chart shows planned timing. You can make it more useful by adding a Progress column.

Enter progress as a percentage, such as 0%, 50%, or 100%. Then create a second conditional-formatting rule for completed work:

=AND(F$1>=$B2,F$1<=$D2,$E2=100%)

Use a darker shade for completed tasks. Keep the original rule for planned tasks, then place the completed-task rule above it if your formatting settings allow rule prioritization.

For a simpler approach, add a Status column with values such as Planned, Active, Blocked, and Complete. This gives you a quick explanation when a task bar changes color.

What a Simple Gantt Chart Shows

A Gantt chart places project activities on a calendar timeline. Each horizontal bar represents a task, and the bar’s position shows when the task begins, how long it lasts, and when it ends.

For example, a content planning bar from June 2 through June 4 immediately shows its place in the schedule. A development bar from June 8 through June 12 reveals a gap between planning and development.

The essential parts

• Task list: The activities required to complete the project.
• Start date: The planned beginning of each activity.
• Duration: The number of calendar or working days assigned.
• End date: The planned finish date.
• Timeline: The calendar running across the chart.
• Task bar: The colored range showing each task’s timing.

These parts work together like a project map. The task list tells you what is happening, while the timeline shows when it happens.

What the chart does not show automatically

A simple Google Sheets chart will not automatically understand task dependencies, workload limits, approvals, or team availability. You have to represent those details with extra columns, formulas, or notes.

For instance, “Design review” may depend on “Content planning.” The chart can show both dates, but it will not necessarily warn you when the review begins before planning ends.

That limitation matters when your schedule has many linked tasks. A 10-task marketing plan may work well in Sheets. A 200-task product launch usually needs stronger project controls.

Build the Chart Around Working Days

The first version usually counts calendar days. Many teams need working days instead because weekends and holidays do not represent active project time.

Calculate an end date with workdays

Suppose the start date is in B2 and the duration is in C2. Replace the earlier end-date formula with:

=WORKDAY(B2,C2-1)

This formula skips Saturdays and Sundays. A five-day task beginning on Monday ends on Friday, even though five calendar positions appear in the schedule.

For holidays, create a small holiday list in another area and reference it:

=WORKDAY(B2,C2-1,$L$2:$L$10)

Here, the range L2:L10 contains dates such as company holidays or office closures.

Adjust the conditional-formatting rule

If your timeline still includes every calendar date, weekend columns may remain visible. You can hide their task colors with a more specific formula:

=AND(F$1>=$B2,F$1<=$D2,WEEKDAY(F$1,2)<6)

This shades weekdays only. You can combine it with holiday logic when your schedule needs a more accurate working calendar.

Example: a two-week campaign

Imagine a campaign with these activities:

A calendar-day chart may make the campaign look longer than it really is. Workday formulas show the schedule your team can realistically complete during business hours.

Make the Timeline Easier to Read

Good formatting helps someone understand the project within seconds. The goal is a clear schedule, rather than a crowded grid filled with equally strong colors.

Use consistent visual signals

Choose one main color for planned work. Add a second color for completed work and a third color for blocked activities. Avoid assigning a different color to every task because the chart becomes visually noisy.

For example, blue can represent planned work, green can represent completed work, and red can represent blocked work. Add a Status column so the color has a clear meaning.

Separate phases with blank rows

Large projects become easier to scan when you group related tasks. You might place a phase label before research, design, development, testing, and launch.

Use bold text, a darker fill, or a blank row between phases. This creates visual breathing room without changing the formulas.

Mark important milestones

Milestones are single dates rather than multi-day activities. Examples include a client approval, product release, or compliance review.

Add a Milestone column or create a special row with a one-day duration. Use a diamond symbol such as ◆ in the timeline, or apply a separate conditional-formatting color.

A milestone gives your team a quick checkpoint. If “Launch approval” is scheduled for July 20, everyone can see which activities must finish beforehand.

Highlight today’s date

To show the current day, apply conditional formatting to the timeline range with this formula:

=F$1=TODAY()

Choose a vertical highlight color that differs from task bars. The line will update automatically each day.

This is useful during weekly reviews because you can see whether active tasks are ahead, on schedule, or behind the current date.

Common Mistakes When Building a Gantt Chart

Most problems come from date formatting, inconsistent formulas, or unclear scheduling assumptions. A quick review can prevent small errors from spreading across the entire plan.

Using text instead of real dates

If a date looks correct but the conditional rule does nothing, the value may be text. Click the cell and check whether Google Sheets recognizes it as a date.

Try changing the format to Format > Number > Date. If the value remains misaligned, re-enter the date using a consistent format.

Counting the duration incorrectly

A duration of one means the task occupies its start date. The end-date formula should therefore use:

=StartDate+Duration-1

If you omit the subtraction, every bar extends one day too far. This becomes especially noticeable when several tasks must finish before a fixed milestone.

Overwriting formulas

When you manually type over a formula, later changes may produce inconsistent end dates or missing bars. Keep calculated columns separate from manual-entry columns.

You can protect formula ranges by selecting the cells, opening the context menu, and choosing the option to protect the range. This reduces accidental edits during collaboration.

Making the chart too wide

A daily timeline works well for short projects. For a six-month plan, hundreds of daily columns create excessive scrolling.

Use weekly columns for longer schedules. Set the first date to the beginning of the week, then add seven days in each later column. Your conditional formula can still compare each task against the weekly date.

Ignoring dependencies

A bar can show timing without showing relationships. If a testing task depends on development, add a Predecessor column with a task identifier.

During each review, confirm that predecessor tasks finish before dependent work begins. For a small project, this manual check may be enough.

When Google Sheets Is the Right Choice

Google Sheets works well when you need a lightweight schedule, a quick visual plan, or a shared planning area for a small team.

It is a practical choice for a two-week event, a simple content calendar, or a short internal project with fewer than 20 tasks. You can build the chart quickly and adjust it without learning specialized software.

Good use cases

• Simple marketing campaigns
• Small event plans
• Personal study schedules
• Short website projects
• Basic renovation timelines
• Early project estimates

For example, a freelance designer planning five deliverables can use a Sheets Gantt chart to show kickoff, drafts, feedback, revisions, and final delivery.

When to consider a project platform

A dedicated project platform becomes more useful when your plan includes many assignees, frequent status changes, dependencies, approvals, recurring work, or detailed reporting.

Consider a larger tool when people need notifications, workload views, sprint planning, permission controls, automation, or a searchable knowledge hub alongside the schedule.

Here’s the practical test: if maintaining the chart takes longer than discussing the work, your planning method may need more structure.

Natural Topic Solution: ONES.com

ONES.com combines project management and knowledge management in one platform, with AI capabilities powered by ONES Assistant. ONES Project is the project-management product and a Jira alternative, while ONES Wiki is the knowledge-management product and a Confluence alternative. They are sold separately.

For a small schedule, Google Sheets may be enough. When your timeline grows into a working project system, ONES.com can connect tasks, workflows, reporting, and team knowledge in a more structured environment.

Core Capabilities

• Scattered task planning → ONES Project: Jira-compatible workflows organize tasks, statuses, and project stages in one place. The result is a clearer path from planned work to completed work.
• Manual timeline maintenance → Gantt and scheduling views: Project schedules can represent timing more directly than manually colored cells. The result is less repetitive formatting when dates change.
• Inconsistent project processes → Custom workflows: You can tailor statuses and approval steps to match your team’s process. The result is better alignment between the schedule and actual delivery work.
• Limited task detail → Custom fields: Add priority, owner, risk, release, department, or other project information. The result is more useful filtering and easier project reviews.
• Heavy plugin dependence → Native capabilities: Sprint management, automation, reporting, and workflow functions are built into the platform. The result is fewer separate extensions to maintain.
• Disconnected project knowledge → ONES Wiki: Teams can keep planning guidance, requirements, decisions, and technical notes close to project work. The result is less time spent searching for context.
• Restricted deployment requirements → Four deployment options: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments. The result is more flexibility for teams with strict infrastructure requirements.
• Different environments → Feature parity: The cloud and self-hosted versions provide full feature parity. The result is a more consistent experience when deployment requirements change.
• Small-team budget pressure → Free plan: The free plan supports up to 30 seats. The result is a low-risk way to test the platform with a small group.

Application Scenarios

Scenario 1: A software team moving beyond a manual schedule. A development team may start with a Google Sheets Gantt chart for release planning. As sprint work, bugs, approvals, and reporting increase, ONES Project can provide Jira-compatible workflows, sprint management, custom fields, and automation in one project environment.

Scenario 2: A regulated team with deployment restrictions. A company may need project management inside an On-Premise, Private Cloud, or Air-gapped environment. ONES.com supports those deployment choices while maintaining feature parity with its cloud version.

Scenario 3: A team connecting work with guidance. A product group may keep project tasks in ONES Project and requirements or decisions in ONES Wiki. This arrangement helps people find the reasoning behind a task without maintaining separate systems for every project phase.

Common Challenges and Practical Fixes

Challenge: The bars do not appear

Likely cause: The dates are stored as text, or the conditional-formatting range does not match the formulas.

Fix: Format the date cells as dates, confirm that the timeline contains real date values, and check whether the rule begins with the same timeline column you selected.

Challenge: Every task bar is shifted

Likely cause: The formula references the wrong row or column.

Fix: For a timeline beginning in F1, use references such as F$1, $B2, and $D2. The row number should change as the rule moves down the task list.

Challenge: Weekend work creates confusion

Likely cause: The schedule counts calendar days while the team plans in working days.

Fix: Use WORKDAY for end dates, shade weekends, and include holiday dates when necessary.

Challenge: The chart becomes difficult to maintain

Likely cause: Too many tasks, manual color changes, or separate schedule versions.

Fix: Keep formulas in dedicated columns, use conditional formatting, add status fields, and review whether a project-management platform would reduce maintenance.

Challenge: People cannot tell what needs attention

Likely cause: The chart shows timing without ownership, status, or risk information.

Fix: Add Owner, Status, Priority, Risk, and Notes columns. A timeline becomes more useful when it explains who acts next and what could delay the work.

FAQs

Can I create a Gantt chart in Google Sheets without an add-on?

Yes. You can build a simple version with task names, start dates, durations, end dates, calendar dates, and conditional formatting. The key formula is =AND(F$1>=$B2,F$1<=$D2). This approach works well for small projects with straightforward schedules.

What formula creates the task bars?

The task bars come from a conditional-formatting rule rather than a chart object. If the timeline begins in F1, use =AND(F$1>=$B2,F$1<=$D2). The rule fills a cell when its timeline date falls within the task’s start and end dates.

How do I exclude weekends?

Use =WORKDAY(B2,C2-1) to calculate an end date that skips Saturdays and Sundays. You can also add WEEKDAY(F$1,2)<6 to the conditional-formatting rule so task colors appear on weekdays only.

Can I track task progress in the same chart?

Yes. Add a Progress column with percentage values and a Status column with labels such as Planned, Active, Blocked, and Complete. You can then add conditional-formatting rules that use different colors for completed or blocked tasks.

How many tasks can a simple Sheets Gantt chart handle?

There is no single practical limit because usability depends on the number of timeline columns, formulas, and formatting rules. A chart with 10 to 30 tasks is usually easy to manage. Larger plans may become difficult to read and maintain, especially when many tasks overlap.

Is a Gantt chart the same as a project plan?

No. A Gantt chart focuses on timing and sequence. A complete project plan may also include scope, owners, costs, risks, requirements, dependencies, communication rules, and approval details. The Gantt chart is one visual part of that broader planning process.

Conclusion

To make a simple Gantt chart in Google Sheets, create task rows, add start dates and durations, calculate end dates, place calendar dates across the top, and use conditional formatting to shade each task’s schedule.

Start with a small example, such as a five-task campaign. Then improve it with working-day formulas, weekend shading, progress tracking, milestones, and status fields. These additions make the chart more accurate without making the setup overwhelming.

But here’s the truth: a manual chart works best while the project remains simple. When dependencies, reporting, approvals, automation, and team knowledge become central to delivery, a structured platform such as ONES.com may provide a more sustainable workflow.

The solution is to match the planning method to the project’s complexity. Use Google Sheets for a quick visual schedule, and move to a dedicated project environment when maintaining the chart starts taking attention away from completing the work.