Docs tower · floor
How to make a graph in Google Sheets, and keep it live
How to make a graph in google sheets is two clicks — select the cells, Insert › Chart — and every page answering the question stops there. Which leaves out the part that makes Sheets worth using for this at all: the chart does not have to be a picture. It can stay attached to the numbers, inside a document or a presentation somebody else is reading.
Select the cells first, then Insert › Chart. The Chart editor opens on the right and has
two tabs, which is the whole interface. Add another range is the one worth remembering. It is the answer to the most common shape
problem in a spreadsheet — the labels are in column A and the figures you want are in column F, with
four columns in between that have nothing to do with the chart.Insert › Chart, then everything happens in one panel
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.
What the link actually does, in Google’s words
In or on, graph or chart. How to make a graph in google sheets, how to make a graph on google sheets, how to create a chart — one feature, one menu. Google calls it a chart throughout its own documentation, which is worth knowing when you go looking: the Insert menu has no entry called graph.
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.
Google’s own warning, read 22 August 2026, and it appears on none of the tutorial pages that answer
this question. The chart carries its picture out past the spreadsheet’s permissions. Link a
chart from a restricted sheet — salaries, a pipeline, patient counts — into a deck shared with the
whole company, and everyone who opens the deck sees the chart. The spreadsheet stays locked. The
numbers in it, in the shape you charted them, do not.“People with access to your document or presentation will be able to view all linked
charts, tables, or slides, even if they don’t have access to the file containing the original
charts, tables, or slides.”
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.
Where to start
Four ways in.
- “I just need a chart.”
- Two clicks, above — the chart editor
- “My data is in two separate columns.”
- Add another range — the chart editor
- “I need it in a slide deck.”
- Link it, and read the warning — linking it elsewhere
- “Which chart should this be?”
- That question is settled in choosing the chart
The chart editor
Two tabs, Setup and Customize, and almost everything people search for separately lives in one of them.
Linking it elsewhere
The capability that distinguishes a Sheets chart, and the permissions consequence Google states and nobody repeats.
Choosing the chart
Which shape fits the data is the same question in every spreadsheet, and Microsoft happens to publish the clearest rules for it.
The numbers underneath
A chart is a picture of a range, and most chart problems are range problems wearing a disguise.
What this tower will not do
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 floor 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 steps, the editor tabs and the warning about linked objects are quoted from Google’s own Docs Editors documentation, with the date each page was read.
Where this page got its facts
- Google Docs Editors Help — Add and edit a chart or graph, including the Insert route, the Setup and Customize tabs, the data range, Add another range and which chart types accept gridlines — support.google.com, read 22 August 2026.
- Google Docs Editors Help — Link a chart, table, or slides to Google Docs or Slides, including the warning that linked objects are visible without access to the original file, the one-way flow of edits and the 400-cell table limit — support.google.com, read 22 August 2026.
Written by Alberto Gulotta
Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.
Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.
Written on 22 August 2026.
Independence and limits
No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.
This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.