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.


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

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

  1. Kristin M Reply

    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! 🙂

  2. Barb Moses Reply

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

  3. Jonathan Palles Reply

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

  4. Andrew S Reply

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

  5. LBbaum Reply

    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?

  6. Paulette Reply

    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?

  7. Leah Reply

    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?

Leave a Reply

Your email address will not be published. Required fields are marked *