How to Make a Gantt Chart in Google Docs


Every time you have to track or discuss project processes, you may think that it will be great to have created a Gantt chart and share it with team members. There Google Docs would give you an answer, although the process can be tedious and a little complex.

How would you like to create your Gantt Chart?

How to Make a Gantt Chart in Google Docs

Step 1: Prepare Your Project Data

Before you make a Gantt chart, the first thing you need to do is to prepare the project data, which should at least include task names, start dates, finish dates and duration days. Then you can save the data in Your Google spreadsheet.

example data

To know how to prepare the data, please (see the tutorial here).

Step 2: Insert a Bar Graph

Open a blank Google document on Your Google Docs, go to the File tab, click Chart on the drop-down menu and choose Bar.

insert chart option

A bar graph will be inserted on the page, click the Open Source button on the upper right corner of the chart, an untitled spreadsheet is open.

In the untitled spreadsheet, you need to paste the data (including task names, processed start dates and duration days) into the table, select Stacked bar chart on the drop-down menu. Thus, the example chart will become a stacked bar chart with the start date and duration.

example bar graph

Step 3: Transform the Bar Graph into a Gantt Chart

However, to make the bar chart look more like a Gantt chart, click to select all the blue bars (Start Date), go to the Customize tab on the Chart editor pane, then choose None on the Color option for the bars of Start Date.

format bar color

After all these instructions, you can go back to the document and you will see an update button on the chart. Click on the button, the original chart will turn into the Gantt chart you made.

example gantt chart

Step 4: Insert a Chart From Sheets

Except for inserting a bar chart, you can also insert the Gantt chart from Google Sheets on the page directly.

Since you have to process the data in Google Sheets, you could (make a Gantt chart in Google Sheets) altogether.

Go to the File tab, click Chart > From Sheets. Follow the instruction, select the right spreadsheet, the Gantt chart would be imported into the page.

How to Make a Gantt Chart in EdrawMax

Frankly speaking, it’s a little bit troublesome to create a Gantt chart in Google Docs instead of Google Sheets or any project management software. Here we would tell you how easy it is to make a complex or large Gantt chart in EdrawMax, which is an all-in-one diagram maker.

Step 1: Find Your Favorite Gantt Chart template

When you enter EdrawMax, you will find there are plenty of pre-made templates for users. Find a Gantt chart template that you like, click on the thumbnail to open the template, then you can type or paste text on the chart.

edrawmax gantt template

Step 2: Start From a Blank Template

If you intend to import your project data and let EdrawMax auto-create a Gantt chart, click on the plus icon and open a blank template.

 Click on the Gantt Chart icon edrawmax gantt chart icon on the right sidebar, hit the Import button on the Gantt Chart pane. Follow the instructions to import the data and the Gantt chart will be like:

edrawmax import data

By the way, the data that you want to import should also include task names, start dates, finish dates, duration days, etc., as the below table is shown, so EdrawMax can identify the data of each task more correctly.

edrawmax example data

Step 3: Customize Your Gantt Chart

In EdrawMax, there are also lots of powerful formatting tools to help users customize Gantt charts or other kinds of diagrams.

If the Gantt chart is auto-generated by EdrawMax, you can go to the Fill/Line/Shadow pane (edrawmax style icon) and Gantt Chart pane for changing fill colors, line styles, shadow effects or modifying task information.

How to Export a Gantt Chart to Word

In Google Docs, you can download the Gantt chart as many common document formats. Go to the File tab, click Download on the drop-down menu and you can select Microsoft Word (.docx) on the menu, therefore, the Gantt chart will be saved on your computer as a Word file.

google docs download

In EdrawMax, go to File tab, click on Export on the drop-down menu. EdrawMax supports to export EdrawMax diagrams into different file types like graphics (.png or .jpeg), PDF and MS Office file formats ( .docx, .pptx and .xlsx) .

What’s more, all the MS Office files exported from EdrawMax are editable and printable. So you don’t need to worry about that non-Edraw users can’t view or edit your Gantt charts.

edrawmax export all
download EdrawMax EdrawMax online
main page