How to make a Gantt chart in Google Docs
Worth knowing before you start looking for it: Google Docs has no way to build a chart from data. The Insert menu offers bar, column, line and pie, and every one of them creates a Google Sheet behind the scenes to hold the numbers. There is no data editor inside Docs itself. That sounds like bad news and mostly is not, because the linked chart it produces is the one genuinely good thing about doing this in Docs - the document updates when the plan does. Three approaches are below, and which one you want depends on whether the dates are still moving.
First, fix the page
Same constraint as any document, and it decides your design rather than decorating it. Go to File > Page setup and switch to Landscape, then reduce the margins to around 1.3 centimetres. That takes the usable width from roughly sixteen centimetres to about twenty five.
Then decide the column unit before drawing anything. One column per week handles most plans up to six months. Daily columns are almost never viable on a page - a three month plan needs about ninety of them.
If only the timeline needs to be landscape, Docs handles this the same way Word does: Insert > Break > Section break either side of it, then change the orientation with the cursor inside that section.
Method 1: build it in Sheets and link it
This is the method to use if the plan is still moving, and it is the only one here where the document stays honest without you maintaining it.
- Build the chart in Google Sheets first. The short version is a stacked bar chart with three columns - task, a start offset, and a duration - where you set the offset series to zero percent opacity so only the duration bars show. The full walkthrough, including the two anchoring mistakes that break it, is in the guide to building a Gantt chart in Google Sheets.
- In your document, go to Insert > Chart > From Sheets.
- Pick the spreadsheet, then pick the chart.
- Leave Link to spreadsheet ticked. This is the whole point.
- Resize it on the page. Charts insert small; drag a corner handle so it fills the width you set up earlier.
The submenu is also the proof of the point above: bar, column, line and pie, plus From Sheets, and nothing that plots data on the page itself.
From then on, when a date changes in the sheet, an Update button appears on the chart inside the document. One click and the picture is current.
That behaviour is worth pausing on, because it is the one real advantage Docs has over the equivalent job in Word. In Word, linking a chart to a workbook is usually a mistake - the link breaks the moment the file is emailed to someone who does not have the spreadsheet. Here both files live in Drive, both are shared by link, and anyone who can open the document can be given access to the sheet behind it. The link survives being shared, which is exactly the case where a Word link fails.
Two things to know. The chart does not refresh on its own; somebody has to click Update, so a reader who does not have edit access may be looking at an old picture. And anyone you share the document with needs access to the underlying sheet as well, or the chart will show but not update for them.
Method 2: draw it
Best when the timeline has to look a specific way, is going into a proposal, and is never going to change.
- Go to Insert > Drawing > + New.
- Draw a line across the bottom as your time axis and add text boxes beneath it for the dates.
- Use the shape tool to draw the first bar as a rectangle. Format it, then copy and paste it for every other task so the heights match.
- Select several bars and use Actions > Align and Distribute to line them up. Doing this by eye is what makes hand built timelines look hand built.
- Add diamonds for milestones and, if you want them, arrows between bars for dependencies.
- Click Save and Close. The drawing lands in the document as a single object and can be reopened by double clicking it.
The drawing canvas is a fixed size and does not match your page width, so expect to resize the object after inserting it and to go back in and adjust once you see it at real size. Anything you draw here is decoration - the arrows do not link anything, and moving a bar moves nothing else.
Method 3: a table with shaded cells
The quickest of the three and the easiest for someone else to edit, which matters more than it sounds in a shared document.
- Go to Insert > Table and pick one column for task names plus one per week, and one row per task plus a header.
- Put week starting dates across the top row, kept short.
- Task names down the first column.
- Select the cells a task spans, then use the cell background colour control in the table toolbar to shade them.
- Drag the first column wider, then select the date columns and use Table properties to give them all the same width.
It looks plainer than the other two and it has one property neither of them has: a colleague can update it without knowing anything. There is no spreadsheet to find, no drawing canvas to open. They select some cells and change the colour. For a plan that lives inside a shared document and gets adjusted by several people, that is often the deciding factor.
Which method should you pick?
| Area | Linked Sheets chart | Drawing | Shaded table |
|---|---|---|---|
| Setup time | 20 minutes, mostly in Sheets | 20 to 30 minutes | 10 minutes |
| Stays current | Yes, one click to update | No | Only if edited by hand |
| Looks polished | Clean chart | Whatever you make it | Plain |
| Editable by a colleague | Needs sheet access | Awkward | Anyone can shade a cell |
| Accuracy | To the day | To wherever you dragged it | To the nearest column |
If the plan is live, use the linked chart. If the document is a deliverable, use the table unless it has to look impressive, in which case draw it.
What none of these will do
Recalculate. In all three methods every date is a value somebody typed, and nothing knows that testing follows build. When build slips a week, nothing after it moves.
The linked chart softens this but does not solve it. It keeps the document in step with the spreadsheet, which is a genuinely useful thing, but the spreadsheet itself has no dependencies either. You are still opening the sheet and editing every downstream date by hand - the link just means you do not also have to redraw the picture. That is the difference between one manual job and two, not between manual and automatic.
Three other things worth knowing before you commit a document to this:
- No critical path. Without links between tasks there is no chain to trace, so you cannot see which tasks are actually setting your end date.
- No baseline. Comparing planned against actual means keeping a second copy of the dates and diffing them yourself.
- Shared editing drifts. A document anyone can edit, holding dates that nothing validates, accumulates small contradictions that are hard to spot.
A better division of labour
Keep the schedule somewhere it can recalculate, and let the document quote it.
The document is the right home for scope, assumptions and commitments. It is a poor home for dates that are going to move. Ganttile is free and runs in the browser, so linking tasks so later dates shift on their own takes about as long as the Sheets build behind method one. Update it once when something slips, then paste a current picture into the document.
If the project also needs boards, comments and files around the timeline, Breeze is the broader version of the same idea.
And if you are weighing this against doing the whole thing in Office instead, the Excel build has one extra step and one fewer sharing problem.
Common questions about Gantt charts in Google Docs
- Can I build a chart in Google Docs without using Sheets?
- Not from data. Every chart type in the Docs Insert menu creates a linked Google Sheet to hold the numbers, and there is no data editor in Docs itself. The only ways to avoid Sheets entirely are the drawing and the shaded table.
- Why is my inserted chart not updating?
- Linked charts do not refresh on their own. An Update button appears on the chart when the source sheet has changed, and somebody with edit access has to click it. Readers with view-only access see whatever was last updated.
- Does Google Docs have a Gantt chart template?
- No. The Docs template gallery has proposals and reports but no project timeline. Google's Sheets gallery is closer, though a Gantt chart still has to be built there rather than picked off a shelf.
- How do I stop the table columns resizing as I type?
- Select the date columns, open Table properties, and set an explicit column width rather than leaving it automatic. Otherwise Docs widens any column whose text does not fit and pulls the grid out of alignment.
Where to start
Set the page to landscape, decide on weekly columns, then pick by how alive the plan is. Live plan, linked chart from Sheets. Finished document, shaded table. Something that has to impress, a drawing.