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.

Practice

1. What is the main benefit of linking a Google Sheet chart to a Google Slides presentation?

easy

A. The chart data is deleted from the Sheet after linking

B. The chart becomes editable directly in Slides

C. The chart is converted to an image and cannot be updated

D. The chart updates automatically when the Sheet data changes

Solution

1. Step 1: Understand linking purpose and update behavior

   Linking keeps the chart connected to the Sheet data so it can update. When data changes in Sheets, the linked chart in Slides can refresh to show new data.

2. Final Answer:

   The chart updates automatically when the Sheet data changes -> Option D

3. Quick Check:

   Linking means auto-update [OK]

Hint: Link means updates flow from Sheets to Slides [OK]

Common Mistakes:

• Thinking chart edits happen in Slides
• Assuming chart becomes static image
• Believing data deletes after linking

2. Which menu option in Google Slides allows you to insert a linked chart from Google Sheets?

easy

A. Insert > Chart > From Sheets

B. File > Import > Chart

C. Edit > Paste Special > Linked Chart

D. View > Linked Objects > Add Chart

Solution

1. Step 1: Locate chart insertion path

   In Slides, charts from Sheets are inserted via the Insert menu. The path is Insert > Chart > From Sheets to link a chart.

2. Final Answer:

   Insert > Chart > From Sheets -> Option A

3. Quick Check:

   Insert menu has chart options [OK]

Hint: Use Insert > Chart > From Sheets to link charts [OK]

Common Mistakes:

• Looking under File or Edit menus
• Trying to paste charts without linking
• Searching in View menu for charts

3. You linked a chart from Sheets to Slides. After updating the data in Sheets, what happens when you open the Slides file?

medium

A. The chart remains unchanged and cannot be updated

B. The chart updates automatically without any prompt

C. Slides shows a prompt to update the linked chart

D. The chart is removed from Slides

Solution

1. Step 1: Understand update behavior on open

   Slides detects changes in linked Sheets data and prompts to update. User must click the prompt to refresh the chart with new data.

2. Final Answer:

   Slides shows a prompt to update the linked chart -> Option C

3. Quick Check:

   Update prompt appears on open [OK]

Hint: Look for update prompt when opening Slides [OK]

Common Mistakes:

• Expecting automatic update without prompt
• Thinking chart updates without user action
• Assuming chart disappears after data change

4. You inserted a linked table from Sheets into Slides, but the 'Update' button is missing when data changes. What is the likely cause?

medium

A. The Sheets file is not shared with Slides

B. The table was pasted as an image, not linked

C. Slides does not support linked tables

D. The Sheets data is empty

Solution

1. Step 1: Check insertion and update button

   If pasted as an image, no link exists to update data. Only linked objects show the update button in Slides.

2. Final Answer:

   The table was pasted as an image, not linked -> Option B

3. Quick Check:

   Update button missing means no link [OK]

Hint: Ensure you insert linked, not pasted images [OK]

Common Mistakes:

• Assuming sharing affects update button
• Believing Slides can't link tables
• Thinking empty data removes update button

5. You want to create a presentation that always shows the latest sales data from your Google Sheet. Which steps correctly link and update the data in Slides?

hard

A. Insert chart from Sheets, then click 'Update' in Slides when data changes

B. Copy chart as image from Sheets and paste in Slides, then replace manually

C. Export chart as PDF and insert in Slides, update by re-importing

D. Use Slides' built-in chart tool and manually enter data

Solution

1. Step 1: Insert and update linked chart

   Use Insert > Chart > From Sheets to link the chart for live updates. When Sheet data changes, click 'Update' in Slides to refresh the chart.

2. Final Answer:

   Insert chart from Sheets, then click 'Update' in Slides when data changes -> Option A

3. Quick Check:

   Link + Update = latest data shown [OK]

Hint: Link charts and use update button for fresh data [OK]

Common Mistakes:

• Pasting static images instead of linking
• Using export/import instead of linking
• Manually entering data in Slides charts