Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

Here is a Sample Gantt Chart Google Sheets Template Format. You can download, save and use the below link to quickly create simple Gantt chart using Google sheets.

Sample Gantt Chart Google Sheets Template

This Example Gantt Chart Google Sheets Template helps you to make a copy of the template and create new Gantt Chart using Google Spreadsheets. This template is created using Online Google Sheets, free Spreadsheet application from Google.

Gantt Chart – Google Sheets Template

 

Download Latest Gantt Chart – Free Excel Template

Here is the preview of the Google Sheet for Gantt Chart. You can have look and and download the file in xlsx format.

Creating Gantt Chart in Google Sheets

Creating Gantt Chart using Google Sheets is very easy. You can follow the below steps to make a Gantt Chart in Google Spreadsheet:

  • Create the Data required to Populate in the Gantt
  • Add Stacked Bar Chart using Task Name, Start Date, Days Completed and Days Pending Columns
  • The Format the Chart with Required Colors to indicate % Completion and Due.

Create the Data for Gantt Chart

We need to create the Sample data for creating the Gantt Chart in Google spreadsheet. Follow the below steps to prepare example data.

  • Click on the New button in the Google Drive
  • Then go to Google sheets and Click on the Blank spreadsheet
  • Create the data with Task name, Start Date, End Date and Progress
  • Create New Filed with the Formula to create the Gantt Start Number
  • Enter the formula =Value(Start Date-MIN(Start Date Range))
  • Create New Field to Calculate Total Days
  • Enter the Formula =End Date- Start Date +1
  • Create New Field to Calculate Days Completed
  • Enter the Formula = Total Days * Progress
  • Create New Field to Calculate Days Pending
  • Enter the Formula = Total Days – Days Completed

Create the Data for Gantt Chart

Now, let’s create the Chart for the data prepared in the above step.

  • Select Tasks Name and Start Number Filed and Insert Chart
  • Go to Chart Editor and Change the Chart Type to Stacked Bar Chart
  • Click on Add New Series and Select Days Completed Range
  • Again, Click on Add New Series and Select Days Pending Range
  • Change the Series Color of the Start Number to Light Gray 3
  • Set the Series Color of the Days Completed to Green Shade
  • And Change the Series Color of the Days Pending to Red Shade
  • You can’t remove the X-axis, so change the font color same as Chart Color
  • Adjust the Chart just beside the Data Table
Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Last Updated: March 2, 2023

One Comment

  1. Mike October 6, 2017 at 10:15 PM

    Thanks you very much. Simple and very useful.

Leave A Comment