Link a chart, table, or slides to Google Docs or Slides - Computer (2024)

1. On your computer, open a document or presentation in Google Docs or Google Slides.
2. Click Insert Chart From Sheets.
3. Click the spreadsheet with the chart you want to add, then click Select.
4. Click the chart you want to add.
   • If you don't want the chart linked to the spreadsheet, uncheck "Link to spreadsheet."
5. Click Import.

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 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 Paste.
6. Choose "Link to spreadsheet" or "Paste unlinked" and click Paste.

1. On your computer, open a presentation in Google Slides.
2. Select the slides you want to embed.
3. At the top, click Edit Copy.
4. Open a different presentation in Google Slides where you want to insert these slides.
5. At the left, click the slide where you want to insert them.
6. At the top, click Edit Paste.
7. Click Link slides.

1. On your computer, open a presentation in Google Slides.
2. On the left, click the slide you want to add.
3. At the top, click Edit Copy.
4. On your computer, open a document in Google Docs.
5. Click where you want to add the slide.
6. At the top, click Edit Paste.
7. Choose an option, then click Paste.

Open and edit a chart, table, or slide

1. On your computer, open a document or presentation in Google Docs or Google Slides.
2. Click a chart or table to select it.
3. In the top right corner of the chart or table, click Link options Open source.
4. You can now change the original file.

Change the cell range in a table

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 Linked 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 Match spreadsheet data and formatting.

1. On your computer, open a document or presentation in Google Docs or Google Slides.
2. Select a chart, table, or slides you want to unlink.
3. In the top right corner of the chart or table, click Link options Unlink .