How Do You Copy a Chart From Google Sheets?

How Do You Copy a Chart From Google Sheets?

You built the chart, it looks right, and now it needs to be somewhere else. A slide deck. A client report. A page on your website.

So you click it, press the usual keys, and the result is slightly wrong. The chart lands as a flat picture when you wanted it live, or it lands live and keeps updating after the numbers moved on.

The reason is that "copy a chart from Google Sheets" is not one operation. It is four, and Google exposes each one in a different place, under a different label, with different consequences next week when somebody edits the source data.

This guide walks all four routes with the menus Google documents, and says which one you want for each situation.

What Is the Fastest Way to Copy a Chart From Google Sheets?

If the chart is going into a Google Doc or a Google Slides presentation, do not copy it from Sheets at all.

Go to the destination file instead and click Insert > Chart > From Sheets, pick the spreadsheet, pick the chart, and click Import. That route gives you a chart that stays connected to its source data.

If the chart is going anywhere else — an email, a PDF, a Word document, a Slack message — use the "More" control at the top right of the chart in Sheets, choose "Download as", and pick a file type.

You get a static image and the question of live updates disappears.

Everything below is the detail behind those two sentences, plus the two routes that are easy to miss.

Not sure your spreadsheets and reports are actually telling the story your traffic data supports? Get a free SEO audit and see what the numbers say.

Why "Copy" Means Four Different Things Here

Before touching a menu, work out which of these you are actually doing. Choosing the wrong one is what produces the frustrating results.

Duplicating a chart inside the same spreadsheet

You want a second copy of the chart on another tab, or beside the first so you can change one without losing the other.

This is the simplest case and the most forgiving, because the data stays in the same file either way.

Putting a chart into a document or a presentation

You want the chart inside a Google Doc or a Slides deck. This is where the linked-versus-unlinked decision lives, and it is the decision that matters most, because it determines whether next month's version of the report is correct or stale.

Saving the chart as a picture

You want a file on your computer that you can attach, print, or drop into software that has never heard of Google Sheets. Nothing stays connected. That is often exactly the point.

Publishing the chart to a web page

You want the chart visible to people who will never open your spreadsheet, on a page you control. This is a separate mechanism again, with its own sharing consequences.

Four jobs, four routes. Picking the route first makes the rest mechanical.

How Do You Copy a Chart Into Google Docs or Slides, Step by Step

This is the route most people need, and the one most people do backwards. The documented path starts in the destination file, not in the spreadsheet.

Step 1: open the document or presentation that needs the chart. Not the spreadsheet. If you are standing in Sheets with the chart selected, you are already on the harder path.

Step 2: click Insert, then Chart, then From Sheets. Google documents this menu path for both Docs and Slides, so the steps are identical whichever one you are in.

Step 3: click the spreadsheet you want, then click Select. You will see the files you have access to. If the spreadsheet you need is not listed, that is an access problem in Drive rather than a charting problem.

Step 4: click the chart you want to bring in. A spreadsheet with several charts shows each of them here, which is a good reason to give your charts meaningful titles while you are building them.

Step 5: decide about the link, then click Import. The option is a checkbox labelled "Link to spreadsheet", and it is ticked by default. Leave it ticked and the chart stays connected to the spreadsheet. Untick it and you get a one-time snapshot.

That is the whole procedure. Five clicks, one decision.

There is also a copy-and-paste route, and Google documents it explicitly for ranges of cells: select the cells in Sheets, click Edit > Copy, then in Docs or Slides click Edit > Paste and choose either "Link to spreadsheet" or "Paste unlinked" before clicking Paste.

If you paste a chart rather than a range, expect a comparable prompt — but the From Sheets route is the one Google writes down for charts specifically, so it is the one to reach for when you want a predictable result.

Charts are only as good as the tracking behind them. Get a free SEO audit and check your analytics is measuring what you think it is.

How Do You Keep a Copied Chart Up to Date?

A linked chart does not refresh silently. It waits for you, and it tells you it is waiting.

When the source spreadsheet has changed, an Update button appears in the top-right corner of the chart. Click it and the chart redraws from the current data.

If the document has several linked objects and you would rather not hunt for them, click Tools > Linked objects.

A sidebar lists every linked chart, table and set of slides in the file, with an Update all button at the bottom and an individual Update beside each one.

Two details are worth committing to memory here. First, if you see no Update button anywhere, the object is either not linked or already current — an absent button is not a bug.

Second, and more important: when you update, edits made to the original file override changes made in the new file. If somebody has been "fixing" the chart inside the document, clicking Update throws that work away.

To break the connection deliberately, select the chart, click the link options arrow in its top-right corner, and click Unlink. The chart becomes a static object and stops offering to update.

The same menu carries Open source, which jumps you to the spreadsheet the chart came from — the quickest way to answer "where did this number come from" in a report somebody else built.

Reporting on data nobody can trace back to its source is how good campaigns get killed by bad meetings. Get a free SEO audit and start from numbers that hold up.

How Do You Save or Publish the Chart Instead?

Both of these live behind the same control, and it is easy to walk past.

Click the chart in Sheets, then use the "More" control at the top right of the chart. That is the overflow menu attached to the chart itself, not anything in the spreadsheet's main menu bar.

To save it as a file: select "Download as" and choose a file type. Google documents three formats for charts — SVG, PNG and PDF. PNG is the safe default for slides and email. SVG is the one to pick if the chart is going to a designer or onto a large screen, because it scales without going fuzzy. PDF suits printing and formal attachments.

To put it on a web page: select "Publish chart", then choose one of two options. "Link" gives you a URL you can copy and share. "Embed" gives you HTML you paste into your website or blog. Click Publish to confirm.

Publishing is the route to reach for when the audience is wider than your Drive. It is also the route that deserves the most thought before you click, for reasons in the limitations section below.

When Should You Link, and When Should You Paste Unlinked?

The decision comes down to one question: after today, should this chart change?

Link it when the document is a living thing. A monthly dashboard, a shared performance report, a deck somebody presents every week. Link the chart once, and updating it next month is one click rather than a rebuild. This is the case where linking pays for itself repeatedly.

Paste it unlinked when the document is a record. A proposal you sent on a specific date. A board pack. An invoice. Anything whose job is to say what was true at the moment it was written. A linked chart in a historical document is a liability, because somebody will click Update two quarters later and silently rewrite history.

Paste unlinked, or download, when the audience is outside your organisation. Linking carries an access consequence covered below, and a flat picture carries none.

Download as an image when the destination is not a Google file at all. There is no linking to be had in Word, Keynote, or an email body, so do not fight for it.

What Are the Limitations Worth Knowing?

A few of these surprise people at bad moments.

Linked objects are visible to anyone who can open the document. Google states this plainly: anyone with access to your document or presentation can view all linked objects, even without access to the original file. If your spreadsheet holds client data, salaries, or anything that is deliberately restricted, a linked chart is a hole in that restriction. Paste unlinked, or download an image, when the source is sensitive.

Edits do not travel backwards. Changes you make to a linked object inside the document do not copy back to the original. The spreadsheet remains the single source of truth, which is correct behaviour but catches people who assumed the connection ran both ways.

Updating overwrites local changes. Covered above, and worth repeating because it is the most common way work gets lost on this route.

Re-pointing a linked chart at a different spreadsheet is not a documented operation. Google's own page describes Open source for reaching the original file, but no option for swapping a linked object's source. If the underlying file moves or gets rebuilt, plan on inserting the chart again rather than redirecting it.

One adjacent limit is worth knowing because it bites on the same workflow: linked tables larger than 400 cells paste unlinked, and a table that was previously linked cannot be expanded past 400 cells. Charts are not tables, but reports that carry both will hit this.

Published charts are published. A "Link" or "Embed" output is reachable by anyone who has the URL. Treat publishing as a public act, not a convenience.

If you are building reports for clients, the data hygiene matters as much as the design. Get a free SEO audit and find out where your tracking is leaking.

How Does This Compare to the Alternatives?

Versus rebuilding the chart in the destination: Google Docs and Slides can both insert a chart natively, with data you type into a small attached spreadsheet. That is fine for a single illustrative chart with four numbers in it. It is miserable for anything connected to real data, because you are now maintaining two copies of the same figures. Pull from Sheets instead.

Versus a screenshot: a screenshot saves perhaps three seconds and loses on everything else. It captures the chart at screen resolution, usually with a stray grey edge, and it looks soft in anything printed. "Download as" costs nothing extra and gives a clean file.

Versus a dedicated dashboard tool: if the honest answer to "where should this chart live" is "on a screen that refreshes itself", copying is the wrong frame. A reporting tool on the same data beats a linked chart, because nobody has to remember to click Update. Copying charts suits a narrative — a document that argues something — not a monitor.

Versus publishing: publishing wins exactly when the audience has no Drive access and the chart should stay current. That is a narrow but real case, and it is the only route here that serves it.

Final Thoughts

The whole thing collapses into one question asked before you touch a menu: should this chart change after today, and who is allowed to see the data behind it?

Yes and internal, link it. No, paste it unlinked. Not a Google file, download it. Public web page, publish it. Those four answers map onto the four routes, and once you have made the call the clicks are trivial.

The mistake worth avoiding is the default one — copying with the keyboard, pasting into whatever is open, and discovering the consequence a month later when the numbers in the deck no longer match the numbers in the sheet. Thirty seconds of deciding up front saves that entirely.

If you are still shaping the chart itself rather than moving it, our guide to making a chart in Google Sheets covers the chart types and the customisations worth knowing before you start sending it anywhere.