Free demo · Google Slides · Lesson 6 · Intermediate · Linked charts

A chart from Google Sheets that updates

Type the numbers once, in Sheets. A linked chart on your slide stays connected to them, so you never retype a figure.

Children per course

The source: Enrolment 2026 in Google Sheets

Course | Children Art | 24 Sport | 31 Computers | 18 Music | 9
  1. 1Insert › Chart › From Sheets
  2. 2Tick the chart, keep Link to spreadsheet ticked, Import
  3. 3A number changes in Sheets: Music is now 15
  4. 4The slide waits for you: an Update button appears
  5. 5Click Update: the chart redraws
  6. 6Tools › Linked objects lists every linked chart
  7. ✓Update all before every presentation
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

Charts in Google Slides get their numbers from Google Sheets. Build the chart in the spreadsheet, then choose Insert → Chart → From Sheets in Slides, pick the file, tick the chart and keep Link to spreadsheet ticked before you click Import. The chart arrives on the slide and remembers its source. When a number changes in the sheet, the slide does not change silently: an Update button appears on the chart, and one click redraws it with the new figures. Tools → Linked objects lists every linked chart and table of the presentation in one panel and offers Update all, a good habit before every talk. Unlink freezes a chart as it is today. Insert → Chart → Bar, Column, Line or Pie works the other way round: Slides creates a new linked sheet with sample numbers, which you replace with your own. The full course goes on to linked tables, choosing the right chart for the message, data storytelling and decks that show live numbers.

Key points

  • Insert › Chart › From Sheets, with Link to spreadsheet ticked
  • Numbers changed? Click Update on the chart
  • Tools › Linked objects: Update all before you present