Adding a dynamic chart to your Google Slides presentation eliminates the hassle of rebuilding presentation elements from scratch whenever data changes. When you insert a chart prepared in Google Sheets by linking it to your presentation, you can reflect updates from the source file onto your slides with a single click. Thanks to this process, it becomes possible to centrally control both individual charts and all linked objects across the presentation.
Core logic and requirements of inserting a linked chart
When inserting a chart into documents or presentations within the Google Workspace ecosystem, an option is provided to link to an existing spreadsheet. According to official documentation, these object insertion steps must be performed on a computer via a web browser by navigating to docs.google.com or slides.google.com (Google Workspace Support).
The most critical rule introduced by the linking logic is data hierarchy. If you make a direct change to the linked chart in the presentation file, those edits are not copied to the source Google Sheets file. Furthermore, when linked objects are updated, any edits made to objects in the original file will overwrite changes made in the new file. In addition, you can feed multiple different documents or presentations from a single central hub by linking the same linked object to them.
Similarly, for situations where you want to bring cell ranges directly into a presentation, you can also review the instructions in inserting and updating a linked table in Google Slides.
Inserting a new chart from scratch or an existing chart from Sheets
There are two primary methods for inserting charts within Google Slides. The first is creating a new chart from scratch, and the second is importing a chart from a spreadsheet where data has already been entered.
To insert a chart from an existing Google Sheets file:
- On your computer, open your presentation in Google Slides.
- In the top menu, click Insert.
- Hover over Chart and click From Sheets.
- Select the spreadsheet containing the chart you want to add, then click Select.
- Click the chart you want to add. If you want the chart to remain linked to the spreadsheet, make sure the "Link to spreadsheet" checkbox is selected. If you want to insert it without a link, you can uncheck this box.
- Click Import.
If you want to insert a new chart from scratch, you can follow Insert > Chart and select the type of chart you wish to add. When you insert a new chart, it is automatically linked to a new Google Sheet. To update the chart, you must edit the numbers in this newly created Google Sheet. If you use different visual templates in your presentations, you can also compare the alternative structural approaches in creating a Gantt chart in PowerPoint.
Fictional scenario: Quarterly delivery targets report
The following fictional example is designed to demonstrate how linked charts operate during reporting workflows. The data is entirely illustrative.
File Name: Q4_Logistics_Report (Google Sheets).
Dataset: Cells A1:B4 contain values for October (3.2 days), November (2.8 days), and December (2.4 days), with a column chart linked to this range.
Execution Step: The presentation lead follows Insert > Chart > From Sheets in Slides, selects this file, checks the "Link to spreadsheet" box, and imports the chart onto the relevant slide.
Update Moment: When the actual value for December is revised to 2.1 days in the spreadsheet, an Update button appears in the top-right corner of the chart on the slide. When the user clicks the button, the chart instantly reflects the new data.
Opening the source file and editing data
To alter the numerical data underlying a chart positioned on a slide, you can access the source file directly:
- On your computer, open your Google Slides file.
- Click the chart to select it.
- In the top-right corner of the chart, click Link options, then click Open source.
- In the original Google Sheets file that opens, change the data.
Changes made in the original file do not reflect onto the presentation automatically on their own; the update command is expected to be executed on the presentation side.
Updating charts individually or in bulk
When data is updated in the source spreadsheet, two methods are available to synchronize the chart in the presentation:
To update a single chart:
Open the presentation on your computer and click the Update button that appears in the top-right corner of the chart.
To update multiple objects at the same time:
- Open the presentation on your computer.
- From the top menu bar, go to Tools > Linked objects.
- A sidebar opens on the right side of the screen.
- Click Update all at the bottom.
- If you prefer, you can also update objects individually in this panel by clicking the Update button next to specific objects.
If you do not see the Update or Update all button on the screen, your charts might not be linked, or your charts may already be up to date (Google Workspace Support).
Sharing permissions and unlinking rules
There is an important rule noted in the official documentation regarding access permissions when using linked objects: users who have access to your document or presentation can view all linked charts, tables, or slides in the presentation, even if they do not have permissions to access the source file containing the original charts (Google Workspace Support).
If you want to separate the chart in your presentation completely from the source file, you can disconnect the link:
- Open your presentation file on your computer.
- Select the chart you want to unlink.
- In the top-right corner of the chart, click the Link options menu and select Unlink.
Once unlinked, the object is no longer connected to the original file; consequently, changes in the spreadsheet cannot be transferred to the chart on the slide.
Troubleshooting and verification checks
When an unexpected situation occurs during chart management, the following checks should be conducted:
Update or Update all button is not visible: Your charts might not be linked to a spreadsheet (for instance, if "Link to spreadsheet" was unchecked during insertion or if an Unlink command was issued later), or your charts may already reflect the current data in the source file.
Formatting conflicts: Edits you make to the linked chart within the presentation file are not copied to the original file. When linked objects are updated, edits made to objects in the original file will overwrite changes made in the new file.
Platform requirement: To add a chart to a document or presentation, you must navigate to docs.google.com or slides.google.com via a web browser on a computer.
Final checklist
- When selecting the chart from Insert > Chart > From Sheets, ensure the "Link to spreadsheet" box is checked to preserve the connection.
- To edit numerical data, follow Link options > Open source in the top right of the chart.
- Following data changes, click the Update button in the top-right corner of the chart or click Update all in the Tools > Linked objects panel.
- Keep in mind that when you share the presentation with people who do not have access to the source file, they can still view linked objects.
- If you do not want the chart to be affected by data changes in the original spreadsheet, apply the Unlink option via Link options.
Frequently Asked Questions
When I change the data in the source spreadsheet, does the chart on the slide update immediately and automatically?
No. For changes made in the source file to reflect in the presentation, you must click the Update button in the top-right corner of the chart or execute the Update all option from the Tools > Linked objects menu.
Can I relink a chart to the same spreadsheet after unlinking it?
When the Unlink action is performed via Link options, the chart becomes independent. To make the chart linked again, you must re-import the chart with the "Link to spreadsheet" option by following Insert > Chart > From Sheets.
Can a person with access to my presentation also edit the source spreadsheet?
No. Viewers or individuals with access to the presentation cannot open or edit the source file if they do not have access permissions for the original spreadsheet. However, even if they do not have access to the original file, they can view the linked chart in the presentation.
← Back to blog
