0
0
Google Sheetsspreadsheet~15 mins

Geo charts and maps 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 visual map showing sales performance by country to identify strong and weak markets.
📊 Data: You have monthly sales data by country including country names and total sales amounts.
🎯 Deliverable: Create a geo chart in Google Sheets that displays total sales by country with color shading to highlight sales volume.
Progress0 / 7 steps
Sample Data
CountrySales
United States120000
Canada45000
Mexico30000
Brazil55000
United Kingdom70000
Germany65000
France60000
India40000
China90000
Australia35000
1
Step 1: Open Google Sheets and enter the sample data with 'Country' in column A and 'Sales' in column B starting from row 1.
No formula needed for this step.
Expected Result
Data table with countries and sales is visible in columns A and B.
2
Step 2: Select the data range including headers, from A1 to B11.
No formula needed for this step.
Expected Result
Cells A1:B11 are highlighted.
3
Step 3: Go to the menu: Insert > Chart.
No formula needed for this step.
Expected Result
Chart editor opens on the right side.
4
Step 4: In the Chart editor, under 'Chart type', select 'Geo chart'.
No formula needed for this step.
Expected Result
A world map appears showing countries with color shading based on sales.
5
Step 5: In the Chart editor, under 'Setup', ensure 'Country' is set as the location dimension and 'Sales' as the metric.
No formula needed for this step.
Expected Result
Map colors reflect sales values correctly by country.
6
Step 6: Customize the chart by clicking 'Customize' tab, then 'Geo', and set the color scale from light to dark to represent low to high sales.
No formula needed for this step.
Expected Result
Map colors clearly show sales volume differences with a gradient.
7
Step 7: Add a chart title 'Sales by Country' in the Chart editor under 'Customize' > 'Chart & axis titles'.
No formula needed for this step.
Expected Result
Chart title 'Sales by Country' appears above the map.
Final Result
-----------------------------
|       Sales by Country     |
|  _______________________  |
| |                       | |
| |   [World Geo Chart]    | |
| |                       | |
| |  Darker color = Higher | |
| |  sales volume          | |
| |_______________________| |
-----------------------------
✓United States has the highest sales with 120,000.
✓China and United Kingdom also show strong sales performance.
✓Mexico and Australia have lower sales compared to other countries.
✓The geo chart visually highlights strong and weak markets effectively.
Bonus Challenge

Add a filter control to the sheet to allow selecting sales data by year or quarter and update the geo chart dynamically.

Show Hint
Use a dropdown menu with data validation for year/quarter selection and QUERY formulas to filter data before charting.