Gantt Chart Google Sheets Template

Home/Gantt Chart/Gantt Chart Templates/Gantt Chart Google Sheets Template
  • Gantt Chart Google Sheet Template

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 TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference

One Comment

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

    Thanks you very much. Simple and very useful.

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.