Link a chart, table, or slides to Google Docs or Slides
When you insert a chart, table, or slide to Google Docs or Google Slides, you can link them to existing files.
Learn how to add and edit tables that don’t link to Google Sheets.
Add a new chart to a document or presentation
- On your computer, open a document or presentation in Google Docs or Google Slides.
- Click Insert
Chart.
- 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 chart from Google Sheets
- On your computer, open a document or presentation in Google Docs or Google Slides.
- Click Insert
Chart
From Sheets.
- Click the spreadsheet with the chart you want to add, then click Select.
- Click the chart you want to add.
- If you don't want the chart linked to the spreadsheet, uncheck "Link to spreadsheet."
- Click Import.
Add a table from Google Sheets
- On your computer, open a sheet in Google Sheets in Google Chrome or Firefox.
- Select the cells you want to put in Docs or Slides.
- At the top, click Edit
Copy.
- On your computer, open a document or presentation in Google Docs or Google Slides.
- Click where you want to put your table and click Edit
Paste.
- Choose "Link to spreadsheet" or "Paste unlinked" and click Paste.
Insert slides from another presentation
- On your computer, open a presentation in Google Slides.
- Select the slides you want to embed.
- At the top, click Edit
Copy.
- Open a different presentation in Google Slides where you want to insert these slides.
- At the left, click the slide where you want to insert them.
- At the top, click Edit
Paste.
- Click Link slides.
Add a slide to a document
- On your computer, open a presentation in Google Slides.
- On the left, click the slide you want to add.
- At the top, click Edit
Copy.
- On your computer, open a document in Google Docs.
- Click where you want to add the slide.
- At the top, click Edit
Paste.
- Choose an option, then click Paste.
Edit, update, or unlink a chart, table, or slides
Edit a chart, table, or slide
Open and edit a chart, table, or slide
- On your computer, open a document or presentation in Google Docs or Google Slides.
- Click a chart or table to select it.
- In the top right corner of the chart or table, click Link options
Open source.
- You can now change the original file.
Change the cell range in a table
- On your computer, open a document or presentation in Google Docs or Google Slides.
- Click a table to select it.
- Click Link options
Change range.
- Type the range you want, then click OK.
Update a chart, table, or slides in a document or presentation
Update the data in your chart or table
- On your computer, open a document or presentation in Google Docs or Google Slides.
- In the top right corner of the chart, table, or slide click Update.
If you don't see "Update" in the top right corner:
- Your chart, table, or slide may not be linked.
- Your chart, table, or slide may already be updated.
Format your table to match your spreadsheet
- On your computer, open a document or presentation in Google Docs or Google Slides.
- Click a table to select it.
- In the top right corner of the chart or table, click Link options
Match spreadsheet data and formatting.
Unlink your chart, table, or slides from the original file
- On your computer, open a document or presentation in Google Docs or Google Slides.
- Select a chart, table, or slides you want to unlink.
- In the top right corner of the chart or table, click Link options
Unlink
.