Gantt Chart Google Sheets 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