Linking Sheets with Slides in Google Sheets - Dashboard Guide

Dashboard Mode - Linking Sheets with Slides

Dashboard Goal

Show how to link data from Google Sheets to Google Slides so that updates in Sheets automatically reflect in Slides presentations.

Sample Data

Product	Sales Q1	Sales Q2	Sales Q3
Apples	120	150	130
Bananas	90	110	95
Cherries	60	70	80
Dates	40	50	45
Elderberries	30	35	40

Dashboard Components

• KPI Card: Total Sales Q3
  Formula: =SUM(D2:D6)
  Result: 130 + 95 + 80 + 45 + 40 = 390
• Chart: Bar chart showing Sales by Product for Q3
  Data range: A1:D6 (Products and Sales Q3 column)
  Visual: Bars for each product's Q3 sales
• Linked Table in Google Slides: Insert a linked table from the range A1:D6 in Sheets
  Shows all products and sales for Q1 to Q3
  Updates automatically when data changes in Sheets
• Formula for Average Sales per Product:
  =AVERAGE(B2:D2) copied down for each product
  Shows average sales across Q1 to Q3

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |       Bar Chart      |
|  Total Sales Q3: 390 |  Sales by Product Q3 |
+----------------------+----------------------+
|                  Linked Table in Slides                 |
|          (Shows all sales data, auto-updates)           |
+---------------------------------------------------------+

Interactivity

When the sales data in Google Sheets is updated, the linked table in Google Slides can be refreshed with one click to show the latest numbers. The chart and KPI card in Sheets update automatically as formulas recalculate. This keeps the presentation always current without manual copying.

Self Check

If you add a filter in Google Sheets to show only products with Sales Q3 above 50, which components update?

• The KPI Card recalculates total sales for filtered products.
• The Bar Chart updates to show only filtered products.
• The Linked Table in Slides does not update automatically until refreshed manually.

Key Result

Dashboard showing sales data linked from Google Sheets to Google Slides with auto-updating tables and charts.