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

Premium Gantt Chart and PM Templates

Premium Project Management Templates

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.

PREMIUM TEMPLATES
LIMITED TIME OFFER
ON SALE80% OFF
BROWSE ALL TEMPLATES

Advanced Project Planning Templates

Excel Templates

VIEW DETAILS

120+ Project Management Templates Pack

Excel | PowerPoint | Word

VIEW DETAILS

ULTIMATE RESOURCE MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS

50+ Essential Project Management Templates

Excel | PowerPoint | Word

VIEW DETAILS

Project Portfolio Management Templates

Excel | PowerPoint Templates

VIEW DETAILS

50+ Excel Project Management Templates

Excel Templates

VIEW DETAILS

Share This Story, Choose Your Platform!

One Comment

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

    Thanks you very much. Simple and very useful.

Leave A Comment