Edit a chart, table, or slide

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 Down arrow and then Open source.
  4. You can now change the original file.

Change the cell range in a table

Tip: You cannot expand a linked table beyond 400 cells within your document.

  1. On your computer, open a document or presentation in Google Docs or Google Slides.
  2. Click a table to select it.
  3. Click Link options Down arrow and then Change range.
  4. Type the range you want, then click OK.

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 then 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 Down arrow and then Match spreadsheet data and formatting.

Unlink your chart, table, or slides from the original file

  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 Down arrow and then Unlink Unlink .