Gantt Chart Template in Google Sheet in Google Sheet

Gantt Chart Templates are extremely useful for Project Management, Event Tracking or Task Scheduling.

Furthermore, using Gantt Charts in Google Sheet Sheet leaves you with additional advantage of easily collaborating across multiple team members since Google Sheet is 100% and 100% free to use.

In this article we will discuss two ways to using Gantt Charts, via Free Templates or creating a simple Gantt Chart from scratch.

Free Resources

Before we begin, feel free to grab a copy of the templates discussed in this tutorial in your personal Google Drive.

  1. Simple Gantt Chart using Stacked Bar Charts
  2. Gantt Chart Template by Smartsheet

*Kindly Create a copy instead of requesting access

Creating a basic Gant Chart in Google Sheet

While you can rely on freely available templates(covered in next section), creating a simple one from scratch ain’t very difficult either. Follow the below steps:

1. Create a data table with Event Name , Start Date and End Date.

Basic Data - Google Sheet

2. Create a New Table below. Copy paste Task Name(B5:B8) as it is to the new table(B14:B17).

Basic Data - Google Sheet

3. In ‘Days from start’ we will calculate the no of days post the first start date(C5) when the Item started. For Example, in C14 apply the below formula and drag&drop upto C17.

Basic Formula- Google Sheet

4. Similarly, for ‘Duration’ we simply would subtract item ‘End Date’ – ‘Start Date’. Shown below:-

Basic formula- Google Sheet

5. Now Select the data, B13:D17 and goto Menu Options -> Insert -> Chart. Google sheet is smart enough to directly select a Stacked Bar Chart Option for us.

Insert Chart Google sheet

5. In this step, we intend to

  • Uncolor the Blue-Bar
  • Add Data Labels to the Red-Bar
Editing Bar Chart Google sheet
  • Remove the Legend
  • Edit the Chart Title
Editing Bar Chart Google Sheet

At the end of all this, we have a simple Gantt Chart ready. You can tweak the start and end dates in Table 1 to update the chart as required.

Gantt Chart Sample - Google Sheet

Using Freely Available Gantt Chart Template in Google Sheet

Google Sheets Template Gallery though small, but is power-packed with so many useful pre-built templates. Gantt Chart Template is one of them, provided by Smartsheet.

Importing Gantt Chart Template from Template Gallery

1. Open Google Sheets. A page like below should open.

Google Sheets Home Page

2. Click on “Template Gallery” present in top right corner.

3. A whole list of free templates opens should open-up. Something like below:-

Template Gallery Google Sheet

4. Now, Scroll down and you’ll find a host of templates freely available for use. Find the header “Project Management” and download the Gant Chart Template by Smartsheet.

Project Management Templates Google Sheet

5. Below sheet should open up.

Sample Gantt Chart Google Sheet

Using the Gantt Chart Template

The Gantt Chart template is a comprehensive one, and fully on us to edit as per our need. Below are some of the changes you can make to begin with:-

1. Add basic project details.

Editing Gantt Chart - Google Sheet

2. Edit the Task Title, Task Owner, Due Date, Start Date etc. As you would notice fields like duration gets auto calculated.

3. Update the %task complete and color code the days.

Editing Gantt Chart - Google Sheet

In a similar way update the rest of the rows too to complete the overall Gantt Chart.

That’s it on this topic. If you still have any questions, then drop a comment below. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.


I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply