Docs · guide

How to make a graph in Google Sheets, and keep it live

By Alberto Gulotta · Updated 23 September 2026 · 11 min read

To create a graph in Google Sheets: select the cells, then Insert › Chart. What that leaves out is the part that makes Sheets worth using at all — the chart need not be a picture. It can stay attached to the numbers, inside a document somebody else is reading.

1. Lay the data out before you draw anything. Google’s rule for a chart’s range is that the first column becomes the labels on the horizontal axis, the first row becomes the legend, and each row is one series. Get this wrong and no setting later will fix it.
2. Select the cells you want in the chart, labels included. The labels are not decoration: they are where the axis names and the legend come from.
3. Click Insert, then Chart. Sheets draws something at once. Treat it as a proposal.
4. Double-click the chart and open Setup. Under Chart type, click the down arrow and pick the one you actually meant.
5. Add the rest of the data from the same tab. Under Data range, use Grid to reselect, and “Add another range” for columns that are not next to each other.

That covers making one. Now the part that is specific to Google, and the reason a chart built here behaves differently from one built anywhere else.

Graph or chart. Google calls it a chart throughout its own documentation and in the menus, which is worth knowing before you go looking: the Insert menu has no entry called graph. It is the same feature under the other word.

And the choice of shape is not a matter of taste. North Carolina State University’s graphing guide separates them by what the data is rather than by how it looks: a bar graph compares separate items, while “histograms are a specialized type of bar graph used to summarize groups of data”. Sheets will draw either over the same numbers and say nothing.

The practical value is that a monthly report stops being a monthly rebuild. The deck holds a linked chart, the spreadsheet gets this month’s figures, and the chart offers to update. Nobody exports a picture, nobody pastes it in the wrong place, and nobody presents last month’s numbers because they forgot the last step. That is a real saving, and it is why the link is on by default.

So the link is a sharing decision, not just a convenience. Before you insert a chart from a restricted spreadsheet, the question to ask is who will open the document — and if the answer is “more people than can open the sheet”, then unchecking Link to spreadsheet gives you a static picture, which is exactly what you want in that case. The chart still shows what it showed. It just stops being a window.

One more thing to check before you present it. Because updates flow one way, a chart you restyled inside the presentation will lose that styling when the spreadsheet pushes an update — Google is explicit that edits in the original “will override changes made in the new file”. If a chart needs to look a particular way for a deck, style it in the spreadsheet, where the styling survives.

Every quoted line above is from Google’s own Docs Editors documentation, read on 22 August 2026 and listed below. The reading of the permissions warning, and the advice to style in the spreadsheet rather than the deck, are ours.

Not covered here. It will not stop at Insert › Chart. The two clicks are on Google’s own page; what happens after the chart leaves the spreadsheet is what this guide is for.

It will not describe linking as purely a convenience. Google warns that a linked chart is visible to people who cannot open the spreadsheet, and that warning is quoted here in full.

And it will not recommend a charting add-on for something that is one item on the Insert menu. What holds instead is simple: the editor tabs and the warning about a linked chart are Google’s own wording, read on the date this page names.