Link a chart, table, or slides to Google Docs or Slides

Important:

  • 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.
  • When linked objects are updated, any edits to the objects in the original file will override changes made in the new file. Learn how to update linked objects.
    • Tip: If you make edits to the linked chart, table, or slide in your new file, the changes won't be copied to the original file.
  • You can link the same linked object in many different documents or presentations.

Add a new chart to a document or presentation

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. Click Insert and then Chart.
  3. Click the chart type you want to add.

When you add a new chart:

  • It will link to a new Google Sheet.
  • To update the chart, update the numbers in the Google Sheet.
  • Learn how to edit chart data.

Embed tables, charts, & slides

To keep charts, tables, and slides up to date across files, you can embed:

  • Tables and charts in Google Docs and Slides.
  • Slides from one Google Slides presentation in a different one.
  • Slides from Google Slides in Google Docs.

Add a table from Google Sheets

Tip: Tables with more than 400 cells will paste unlinked into your document. You cannot expand a previously linked table beyond 400 cells.

  1. On your computer, open a sheet in Google Sheets in Google Chrome or Firefox.
  2. Select the cells you want to put in Docs or Slides.
  3. At the top, click Edit and then Copy.
  4. On your computer, open a document or presentation in Google Docs or Google Slides.
  5. Click where you want to put your table and click Edit and then Paste.
  6. Choose "Link to spreadsheet" or "Paste unlinked" and click Paste.

Edit, update, or unlink a chart, table, or slides

Update charts, tables, or slides in a document or presentation

Update the data in your chart or table

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. In the top right corner of the chart, table, or slide click Update.

Update the data in multiple charts or tables

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. At the top, click Tools and thenLinked objects. A sidebar will open on the right.
  3. At the bottom, click Update all.

Tip: Click Update next to specific objects to update them individually.

If you don't see "Update" or "Update all":

  • Your charts, tables, or slides may not be linked.
  • Your charts, tables, or slides may already be updated.

Format your table to match your spreadsheet

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. Click a table to select it.
  3. In the top right corner of the chart or table, click Link options Down arrow and then Match spreadsheet data and formatting.

Was this helpful?

How can we improve it?