Embedding charts in Docs and Slides in Google Sheets - Dashboard Guide

Dashboard Mode - Embedding charts in Docs and Slides

Goal

Show how to create charts in Google Sheets and embed them into Google Docs and Slides to share visual data easily.

Sample Data

Month	Sales	Expenses
January	1000	400
February	1200	450
March	900	380
April	1400	500
May	1300	470

Dashboard Components

• Chart in Google Sheets: Create a column chart showing Sales and Expenses by Month.
  Steps:
  1. Select data range A1:C6.
  2. Insert > Chart.
  3. Choose 'Column chart'.
  4. Customize title to 'Monthly Sales and Expenses'.
• Embed Chart in Google Docs:
  1. In Google Sheets, click the chart menu > Copy chart.
  2. Open Google Docs.
  3. Paste (Ctrl+V).
  4. Choose 'Link to spreadsheet' to keep it connected.
  5. Chart appears and updates when data changes.
• Embed Chart in Google Slides:
  1. Copy chart from Google Sheets.
  2. Open Google Slides.
  3. Paste (Ctrl+V).
  4. Choose 'Link to spreadsheet'.
  5. Chart is embedded and updates with data changes.

Dashboard Layout

+----------------------+-----------------------+
|      Google Sheets    |     Google Docs       |
|  [Chart: Sales vs Exp]|  [Embedded Chart]     |
+----------------------+-----------------------+
|     Google Slides     |                       |
|  [Embedded Chart]     |                       |
+----------------------+-----------------------+

Interactivity

When you update sales or expenses in Google Sheets, the embedded charts in Google Docs and Slides show a small update button. Clicking it refreshes the chart to show the latest data. This keeps all documents synchronized with the source data.

Self Check

If you change the sales number for March from 900 to 1100 in Google Sheets, which components update?

• The chart in Google Sheets updates immediately.
• The embedded charts in Google Docs and Slides show an update button to refresh and display the new data.

Key Result

Dashboard shows how to create a chart in Google Sheets and embed it into Google Docs and Slides with live updates.