How to Make a Gantt Chart in Google Sheets

Google Sheets is a perfectly suitable application in G suite for creating Gantt charts and make it easy to share project schedules in your project team. However, you’d have to use the time-consuming features to make a Gantt chart, which is less efficient than in professional tools.

How would you like to create your Gantt Chart?

How to Make a Gantt Chart in Google Sheets

Using Formulas and the Stacked Bar Chart

Step 1: Open a New Spreadsheet

Search Google Sheets on the browser and click to create a new blank spreadsheet.

Step 2: Input the Data of Project

On the new spreadsheet, you at least need to enter or paste the task names, start dates and finish dates for making a Gantt chart. These tasks would be listed in the order of occurrence and the date format should be as follows: Month/Day/Year.

Apart from those, creating a Gantt chart still needs the data of the Duration in Google Sheets, which is the actual amount of the days to complete each task.

input project data

In this example, to calculate the duration days, we use the formula as shown above:

=( int(C2) - int($B$2) ) - ( int(B2) - int($B$2) ). This formula represents “Task Duration = Finish Date – Start Date“.

In the meanwhile, the formula for calculating the column of Start Date (B10 : B15) is that “int(B2) - int($B$2)”. If you don’t figure out this column, it will be hard for you to continue the following steps.

Thus, we get a new table (A9 : C15). This table will be the actual data for creating a Gantt chart in Google Sheets, which is different from creating a Gantt chart in Excel (https://www.edrawmax.com/gantt-chart/how-to-make-a-gantt-chart-in-excel/).

Step 3: Insert a Stacked Bar Graph

Select the new table (A9 : C15), go to the “Insert” tab, click “Chart” on the drop-down menu, and you will see a stacked bar graph and the Chart editor pane shown on the spreadsheet.

insert stacked bar graph

Step 4: Transform the Bar Graph into a Gantt Chart

Click to select all the Start Date bars (the blue bars) on the bar graph, the Chart editor pane will automatically direct into the Customize tab, and you can change the bar color under the Series group.

Click the Color button under the Format option, select None on the color menu.

change bar color

Therefore, the final Gantt chart will be like:

example gantt chart
Using a Pre-made Gantt Chart Template

Open the Template gallery in Google Sheets,  and you will find a Gantt chart template under the Project management category.

Click on the thumbnail to open the template, then you can enter your project information and project data into this template to make your own Gantt chart.

gantt chart template google

Click here to find more free Gantt Chart templates > >

How to Make a Gantt Chart in Edraw Max

You can make a Gantt chart in Google Sheets manually or with the help of pre-made templates. However, both ways can be tricky and time-consuming. Next, we will introduce you to how to streamline the process using Edraw Max.

Step 1: Pick Your Favorite Gantt Chart template

As you can see, Edraw Max provides abundant inbuilt templates for users. If you don’t find desired templates in the application, you can also search on (Edraw Template ) and download any template on your computer.

edrawmax gantt template

Click here to find more free Gantt Chart templates > >

Step 2: Open a Gantt Chart Template

Click on the template thumbnail and Edraw Max will open this template for you automatically.

Or, if you already have downloaded some Gantt chart templates from Edraw Template, you can click the Import button on the Home page, and follow the instructions to open the template in Edraw Max.

edrawmax open template

Step 3: Import Project Data

The other way of making a Gantt chart in Edraw Max is to import the project data and Edraw Max will auto-generate a Gantt chart. Before that, you should arrange the project data and the information of task names, start dates, finish dates, duration days, etc. should be included at least.

edrawmax example data

Open a blank template, click on the Gantt Chart icon edrawmax gantt chart icon on the right sidebar and click the Import button on the Gantt Chart pane. Follow the instructions and the Gantt chart will be like:

edrawmax import data

Step 4: Customize Your Gantt Chart

For using a template, you can use the formatting tools on the Fill/Line/Shadow pane (edrawmax style icon), Page Setup pane (edrawmax page setup icon) and Theme pane (edrawmax theme icon) to change colors, backgrounds and themes.

For importing project data, you can go to the Gantt Chart pane, modify task information, change the columns and data formats shown on the chart.

With these formatting tools, you are able to make any kind of Gantt chart as you like.

How to Export a Gantt Chart to Excel

In Google Sheets, you can download the Gantt chart you make in different file formats. Go to the File tab, click Download on the drop-down menu and you can select Microsoft Excel on the menu, thus the Gantt chart will be exported as an Excel file.

google sheets download

In Edraw Max, go to the File tab, click on Export on the drop-down menu, and you will find that the Gantt chart can be exported and downloaded in many common file types, such as graphics, PDF, Word, Excel, PowerPoint, etc.

Especially, all the MS Office files exported from Edraw Max are editable and printable. It will be more convenient and efficient for you to share your Gantt charts with others.

edrawmax export all

To share your Gantt charts with others, you can also click on the Share button on the drop-down menu or on the upper right corner of the main interface. Then the Shared Successfully windows will pop up and you can choose one of the sharing methods.

edrawmax share window

Related Articles