0
0
Google Sheetsspreadsheet~15 mins

Embedding charts in Docs and Slides in Google Sheets - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a sales analyst at a retail company.
📋 Request: Your manager wants a monthly sales report with charts embedded in Google Docs and Slides for the upcoming meeting.
📊 Data: You have monthly sales data by product category for the first half of the year in a Google Sheet.
🎯 Deliverable: Create charts in Google Sheets and embed them into a Google Doc and a Google Slide presentation, ensuring they update automatically when the data changes.
Progress0 / 10 steps
Sample Data
MonthElectronicsClothingHome Goods
January1200080006000
February1500070006500
March1300090007000
April1600085007200
May1700095007500
June18000100008000
1
Step 1: Open the Google Sheet with the sales data and select the range A1:D7.
No formula needed; just select the data range.
Expected Result
The data range including months and sales figures is selected.
2
Step 2: Insert a chart by clicking Insert > Chart in the Google Sheets menu.
Chart type: Column chart; Data range: A1:D7.
Expected Result
A column chart showing sales by category for each month appears on the sheet.
3
Step 3: Customize the chart title to 'Monthly Sales by Category'.
In Chart Editor > Customize > Chart & axis titles, set Title text to 'Monthly Sales by Category'.
Expected Result
The chart title updates to 'Monthly Sales by Category'.
4
Step 4: Copy the chart by clicking on it and pressing Ctrl+C (Cmd+C on Mac).
No formula; use keyboard shortcut.
Expected Result
The chart is copied to the clipboard.
5
Step 5: Open a Google Doc where you want to embed the chart.
No formula; open the document.
Expected Result
Google Doc is open and ready for pasting.
6
Step 6: Paste the chart into the Google Doc using Ctrl+V (Cmd+V on Mac).
No formula; use keyboard shortcut.
Expected Result
The chart appears in the Google Doc with a link to the original sheet.
7
Step 7: In the Google Doc, click the 'Update' button on the chart if data changes in the sheet.
No formula; manual update button click.
Expected Result
The chart in the Doc updates to reflect the latest data.
8
Step 8: Open a Google Slides presentation where you want to embed the chart.
No formula; open the presentation.
Expected Result
Google Slides is open and ready for pasting.
9
Step 9: Paste the chart into the Google Slide using Ctrl+V (Cmd+V on Mac).
No formula; use keyboard shortcut.
Expected Result
The chart appears in the slide with a link to the original sheet.
10
Step 10: Click the 'Update' button on the chart in Slides to refresh it when the sheet data changes.
No formula; manual update button click.
Expected Result
The chart in the slide updates to show the latest sales data.
Final Result
Column Chart showing sales data
↓
Same Column Chart embedded
✓Electronics sales steadily increased from January to June.
✓Clothing sales fluctuated but showed overall growth.
✓Home Goods sales grew slowly but consistently.
Bonus Challenge

Set up the Google Sheet chart to update automatically in Docs and Slides without needing to click 'Update'.

Show Hint
Explore Google Workspace add-ons or Apps Script to automate chart refresh.