clickup.com

How To Make A Gantt Chart In Google Sheets (2021 Guide)

gantt-chart-in-google-sheets

Wondering how to make a Gantt chart in Google Sheets?

A Gantt chart is a detailed visualization of your project’s progress. 

At first, looking at it may seem like you’re looking down a rabbit hole of information, full of dizzying details. 

But don’t be intimidated. 

You can easily navigate (and create) your own Gantt chart wonderland in Google Sheets!

And no, you don’t need to be a magical rabbit for this task! Just follow our lead. 

In this article, you’ll uncover what a Gantt chart is, how to create a Gantt chart in Google Sheets, and its limitations. We’ll also recommend a far superior Google Sheets alternative for all your charting needs!

Ready? Let’s dive in.

What Is A Gantt Chart?

A Gantt chart contains information about completed and remaining work in a project in the form of a bar chart. 

It’s a pretty comprehensive chart where you plot every single event, outcome, delivery, and stakeholder in a project.

Project managers use Gantt charts to:

Want to learn more about this amazing project management tool? Check out our detailed guide on Gantt charts and get some inspiration about different Gantt chart examples.

While Gantt charts started off as sophisticated tools for highly trained project managers, any project team member can look at a modern Gantt chart and understand where the project is headed. 

It’s like standing on top of a tower and watching the traffic move. Weirdly empowering!

batman on roof

Looking for a makeshift Robin to your project management Batman?

Try out Google Sheets!

How To Make A Gantt Chart In Google Sheets

Here’s a step-by-step guide on how to create Gantt chart in Google Sheets. 

1. Insert basic data

Create a new Google Sheet  document. 

Then, add basic project data over the:

  • Task name
  • Tasks’ start date
  • End date

The table should look like this: 

gantt charts in google sheets

Now, this is only a reference table. 

Creating the Gantt chart involves calculating task durations, which we’ll do in the next step. 

2. Calculate task durations

Copy-paste the same table a few rows below the original table. 

Now, rename the ‘End date’ column as ‘Task duration’ and delete the data in that column. The rest remains the same. 

Calculate task durations in google sheets

In the first cell of the ‘Start date’ column, copy-paste this formula: =INT(B2)-INT($B$2)

Note: Here, B2 stands for the cell number of the first date in the original ‘Start date’ column. Feel free to change these values if your table positioning is different. 

Once you copy-paste this formula, the sheet converts the date to an integer for the number of days in the date range. In our example, it becomes day 0

gantt in google sheets

Now copy-paste the same formula into each cell, all the way down to the last task in the same column. This will give an absolute integer value to the start date of each task in the project cycle. 

Next, we’ll calculate the task duration. 

To do that, copy-paste this formula in the first cell of the ‘Task duration’ column: =(INT(C2)-INT($B$2))-(INT(B2)-INT($B$2))

Similar to what you did in the earlier step, copy-paste it down to the last task in the same column. The resulting table will show you how long each task takes in a number of days

column calculations in sheets

Note: This does not account for any non working day

3. Generate a stacked bar chart

Select all the cells in the second table, go to Insert in the top menu, and select Chart

Google Sheets automatically generates a stacked bar chart. But you can change the chart type whenever you want. 

Reposition it and edit the chart name. 

Generate a stacked bar chart in google sheets

4. Format the chart

Select the ‘Start date’ portion of the chart. It’s usually the light-themed bars on the chart. 

In our example chart, the blue portions represent the start date. 

Once you select a bar, go to the color menu in the chart editor window and select ‘None.’

This completes the classic Gantt chart look!

formatting a chart in sheets

You can now edit the original data table and see the changes reflect in your Gantt chart. 

The best part about a Gantt chart? 

You just need a single glance to identify any overlapping tasks. 

Take a look: 

gantt in google sheets

Want to learn more about what else you can do with a spreadsheet

Explore Microsoft Excel as a project management tool

3 Google Sheets Gantt Chart Templates

Creating a Gantt chart in Google sheets can be a little complicated, which could leave you like this: 

man confused

Escape the rut of creating a Google spreadsheet from scratch with a Gantt chart Google Sheets template!

You can instantly assemble a hassle free Gantt chart for Google Sheets with these templates.

1. Simple Google Sheets Gantt chart template

Don’t know what you need from your Google Sheet Gantt chart yet? 

Start with this beginner Gantt chart template that fits every project in every industry. 

gantt template for sheets

Download this simple Gantt chart template

2. Event planning Gantt chart Google Sheets template

Let’s be honest, event planning can be very hectic. 

Let this intuitive Gantt chart template share the burden and make your event a success!

event planning chart in sheets

Download this Event planning Gantt chart template google sheets.

3. Construction Google Sheets Gantt chart template

If you have a construction team, build your project, brick-by-brick, with this construction Gantt chart template. 

Construction Google Sheets Gantt chart template

Download this Construction Google Sheets Gantt chart template.

We hope these templates cover all your Gantt chart needs. 

But we know they won’t. 

And that’s because of the glaring flaws in Google Sheets Gantt charts.

3 Drawbacks Of Google Sheets Gantt Charts

Google Sheets is free, flexible, and very difficult to hate!

It’s certainly better than using Excel to make Gantt Charts, any day. 

See, we’re part of the Google Sheets fan club too! 

However, it isn’t a Gantt chart tool.

Read on to see why Google Sheets is not the right tool for creating Gantt charts and why you’ll need Gantt chart software

1. No project task management

Gantt charts are like maps. 

While they’re lovely to stare at, their real use is to help navigate projects. 

Now, you may have a comprehensive Gantt graph in Google Sheets, complete with deadlines and deliverables. However, does it even matter if you can’t use it to navigate your project on the ground?

To do that, you’ll need basic task management functionalities like:

  • Assigning tasks to individuals
  • Scheduling on calendars
  • Managing dependent tasks
  • Estimating the completion date with real-time data, etc.

Google Sheets is no help in this department. Well, you could technically make a calendar in Google Sheets.

But effectively, it gives you a dead Gantt chart. 

Great for slideshows. Not much else, though. 

2. Limited integrations

You can’t pull off a project without your team’s support. 

Similarly, even software needs external help once in a while.    

Good project management software can integrate with other tools to ensure you have everything you need.

Unfortunately, Google Sheets doesn’t. 

It tries its best to compensate with Chrome extensions and add-ons. 

But that’s hardly enough, is it?

3. Limited mobile functionality

Scrolling through a Google spreadsheet on your phone will feel like playing a ‘90s video game, just less fun. 

And you’ll lose each time 😢.

game over pacman

So unless your idea of project management involves being chained to a desk, we don’t recommend Google Sheets. 

Instead, why not pick the world’s highest-rated productivity tool as your go-to Gantt chart maker?

Create Effortless Gantt Charts On ClickUp

ClickUp is THE gateway to smooth project management. 

Why? 

Its power-packed features are designed to turn you into a project management ninja. 

But you aren’t here to learn about all the features, right? 

Just the Gantt charts?

Take a look at how ClickUp’s Gantt charts, Timeline view, and other features smoothen your workflows:

1. Gantt chart view

ClickUp is the only Gantt chart software you’ll ever need.

You’ll never have to leave your online workspace to create elaborate Gantt charts. 

Here’s how you can build one

  • Select the + sign in any List, Folder, or Space
  • Select Gantt
  • Rename it
  • You may choose to make it a Personal
  • Pin the view for quick access
gantt view in clickup

Discover the progress percentage of your project by hovering over the progress bar. 

In the chart’s sidebar, you can see what data ClickUp uses to generate the Gantt chart and even make adjustments to it. 

gantt sidebar

If you think that’s convenient, check out how easy it is to manage task Dependencies and create an automated Gantt chart. 

  • Schedule them by drawing lines between tasks 
  • Reschedule a dependent task with drag and drop actions
  • Delete them by clicking on the dependencies line 
easy peasy gif

And while you’re making that easy lemonade, don’t forget your critical path

It’s the minimum number of tasks you need to finish to meet your project deadlines. 

Calculate your project’s critical path with these steps:

  • Open the Gantt view
  • Click on the Path Calculations icon
  • Hover on Critical Path   
  • Hover on Show Slack Time   
critical path in clickup gantt

Finally, customize the Gantt chart with color schemes that showcase different Priority levels. Right-click on any Task on the chart and turn it into a bright, diamond-shaped Milestone

You can then either share this chart as a PDF or share it directly from your Workspace.

2. Timeline view

A timeline is much less elaborate and more accessible than a Gantt chart. 

Use it to communicate the basics of your project schedule. 

Learn how a project timeline differs from a Gantt chart

You can add one using the exact same process as a Gantt view in ClickUp. 

But don’t let its simple rows and columns fool you. 

The Timeline view lets you:

  • Add tasks by clicking anywhere on the timeline
  • Drop existing tasks into the timeline and adjust their duration
  • Assign tasks to team members with a click
  • Group tasks by Assignees or Priority
  • Find unassigned tasks
  • Track unscheduled or overdue tasks
  • Adjust the time window you want to view tasks in
timeline in clickup

Think we’re done?

Having a ClickUp account is like owning an endless supply of sunglasses because you can view things any way you want! 🕶

Take a look at the other views in ClickUp:

And remember how we said that ClickUp is the only project management software you’ll ever need?

Here are some features that make that true:

  • Native Time Tracking: count the number of hours on each task and project
  • Docs: create elaborate documents about your project plan
  • Goals: track progress towards achieving your project goals
  • Dashboards: keep an eye on key metrics from multiple projects with tons of widgets
  • Pulse: stay connected with your team’s activity throughout the day
  • Profiles: manage your team with a crystal clear view of their workloads
  • Time Estimates: calculate project completion dates with task-wise time estimates
  • Automation: choose from over 50+ ways to get ClickUp to perform repetitive tasks automatically
  • Templates: use a project management template that fits your needs perfectly
  • Integrations: amp up your ClickUp workspace with third-party app integrations like Google Calendar and Google Drive to Google Slide and Google Doc

‘Spread’ The Productivity Around

Google Sheets is a handy tool, but it’s hardly the right vehicle to handle Gantt charts.

Sure, you can create one after a few complex steps.

But even then, you’re pretty limited when it comes to managing projects.

Instead, why not opt for ClickUp, the world’s best project management tool?

Create, assign, manage your tasks, and plot them onto a Gantt chart, all in one place!

Get ClickUp for free today and jump towards success!

deadpool clapping

Questions? Comments? We're here for you 24/7 at help@clickup.com!

Sign up for FREE
and start using ClickUp in seconds!
Please enter valid email address