You might use the same chart in multiple documents and presentations in G Suite. But if that chart changes, it can be very time-consuming to replace it in each and every file. Luckily, Google rolled out an update last week that allows users to embed charts from Google Sheets in Google Docs and Slides and update them with a single click. Use this easy feature to save time and avoid tedious work.

  1. Enter your data into Google Sheets, and click on Insert > Chart to create a chart.
  2. In Google Slides, click on Insert > Charts > From Sheets. Choose the chart you’d like to embed from Sheets.
  3. Make sure the “Link to spreadsheet” box is checked off. This will create a dynamic link between the chart in your presentation and the original data in the spreadsheet. This will work in Docs as well.
  4. If necessary, go back to Sheets and make changes to your data. When you view your chart in Slides, you can click “Update,” and the chart will automatically update.

Click here to watch this video on YouTube.

Shares

UP NEXT: How to Calculate the Amount of Time Between Two Dates in Excel

Leave a Reply

10 Comments on "How to Embed Charts from Google Sheets in Slides and Docs (And Update Them with One Click)"

Notify of
avatar
Sort by:   newest | oldest | most voted
David perko
Guest

This is a great — and much anticipated feature! When will it be available for enterprise clients?

Patrick Hunter
Guest

Sweet…

Kristin M
Guest

In Google Slides, click on Insert > Charts > From Sheets. Choose the chart you’d like to embed from Sheets.

I do not have the option when I click on Insert to select “charts.” Please help! 🙂

Barb Moses
Guest
Barb Moses

I do not have the Insert Charts option in Google Slides or Docs. Why would that be?

Murray Kennedy
Guest

love it, but I do not have the insert/chart option on my google sheets menu… how so?

Jonathan Palles
Guest
Jonathan Palles

I don’t have an option to insert Charts. Am I missing something?

Andrew S
Guest
Andrew S

“3. Make sure the “Link to spreadsheet” box is checked off “… off?

LBbaum
Guest
LBbaum

I actually discovered this by mistake when I copied and pasted a column from Sheets into Docs. It was awesome. I added a Titles column to the left of my data. I updated the data in sheets and when I went back to my doc and clicked on “update” I lost all my formatting including the headings column. Is there a way to prevent this from happening?

Paulette
Guest
Paulette

Hi this was really good to begin with but has time has gone by and I have clicked on update the labels on my slides are no longer showing but still showing on the google sheet why is this?

Leah
Guest
Leah

I am able to embed the chart from Google sheets into Google slides. The problem is that the format doesn’t fully transfer over. Specifically the compare mode does not work in Google slides. It works just fine in Google Sheets. Am I missing something?

wpDiscuz