You built a chart from a Google Sheet, dropped it into a slide, and shipped the deck. Then the numbers changed — and now you're wondering whether there's a way to make the chart on the slide update itself, instead of rebuilding it every time.
There is, sort of. This is the honest map of every option, from the built-in one most people miss to the ones you reach for when the built-in one isn't enough — and exactly where each stops working.
Option 1: Link the chart to the sheet (built-in, and underused)
Google Slides has this natively. When you insert a chart, you can link it to its source spreadsheet:
- In Slides, click Insert → Chart → From Sheets.
- Pick the Google Sheet, then the specific chart from it.
- Import it with "Link to spreadsheet" checked.
Now the chart carries an Update button. When the sheet's data changes, click Update and the chart on the slide redraws with the new numbers. This is the right answer for a lot of decks, and it's free. If you just need the basic mechanics of getting a Sheets chart onto a slide, we cover them step by step in how to insert a Google Sheets chart into Google Slides.
Where it stops: two places.
- It's not automatic. "Linked" doesn't mean "live." You still click Update on each chart, by hand, every time the data moves. Search Google's own support forums and you'll find years of threads asking for a true auto-refresh — there isn't one built in.
- You're limited to Google's chart types. Basic bar, column, line, pie. No waterfall, no 100% stacked bar with totals, no Mekko, no growth deltas between bars — the charts a real board or strategy deck actually needs.
Option 2: Apps Script (free, for people who code)
You can automate the clicking with Google Apps Script. A script can walk every slide, find each linked chart, and call refresh() on it — and a time-driven trigger can run that script on a schedule (say, every morning).
This genuinely works and costs nothing but your time. The catch is that it's a small software project: you're writing, authorizing, and maintaining a script and its triggers, and debugging it when a deck is renamed or a permission lapses. Fine for one important recurring deck you own; overkill for the rest.
Option 3: Zapier or similar (paid, no code)
Automation platforms like Zapier offer a "when rows change in Google Sheets, refresh charts in Google Slides" style workflow. It's the no-code version of the Apps Script route: you get scheduled or triggered refreshes without writing anything.
Where it stops: it's another subscription and another moving part to keep connected, and it's still refreshing Google's chart types — so you inherit Option 1's second limitation. You've automated the update, but not upgraded the chart.
Option 4: A charting add-on that syncs natively (the durable answer for board charts)
If your slides need charts Google doesn't have — waterfalls, 100% stacks with totals above each column, segment labels, growth deltas — the linked-chart route can't get you there no matter how you automate it. The chart type simply isn't available.
This is the gap ChartKit fills. It builds think-cell-style charts directly inside Google Slides, and as of this release it connects a chart to a Google Sheet range and keeps it in sync:
- Point any chart at a sheet range once; it renders and shows a Synced badge.
- When the numbers move, the chart re-renders — hit Refresh, or let it sync when you open the deck.
- Sync updates the data only. Your labels, totals, deltas, colors, and annotations stay exactly as set — the chart doesn't reset when the data changes.
So instead of automating the manual Update click on a basic Google chart, you get a board-grade chart that follows the sheet. Details of what shipped: your Slides charts now live-sync with Google Sheets.
Which one should you use?
| You need… | Use |
|---|---|
| A basic bar/line that updates when you click Update | Native linked chart (Option 1) |
| That, but refreshed on a schedule, and you can code | Apps Script (Option 2) |
| That, on a schedule, no code | Zapier / automation tool (Option 3) |
| Consultant chart types (waterfall, 100% stack, deltas) that stay in sync | ChartKit (Option 4) |
The honest summary: for a plain chart, Google's built-in link is enough — just know it's a manual Update, not true auto-refresh. The moment you need the chart types that make a deck board-ready, or you're tired of clicking Update across a dozen charts every reporting cycle, a charting add-on that syncs natively is the version that actually stops the rebuild.