Scatter plots in Google Sheets - Dashboard Guide

Dashboard Mode - Scatter plots

Dashboard Goal

Understand the relationship between advertising spend and sales using a scatter plot.

Sample Data

Month	Advertising Spend ($)	Sales ($)
Jan	200	1500
Feb	300	1800
Mar	250	1600
Apr	400	2100
May	350	2000
Jun	500	2500

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(C2:C7)
  Result: 11500
• KPI Card: Average Advertising Spend
  Formula: =AVERAGE(B2:B7)
  Result: 333.33
• Scatter Plot Chart: Advertising Spend vs Sales
  Data Range: B1:C7
  Description: Plots each month's advertising spend on the X-axis and sales on the Y-axis to see the relationship.

Dashboard Layout

+----------------------+----------------------+
| Total Sales (KPI)    | Average Ad Spend (KPI)|
+----------------------+----------------------+
|                      Scatter Plot                     |
|               Advertising Spend vs Sales              |
+-------------------------------------------------------+

Interactivity

Add a filter for Month to select specific months. When you choose months, the KPI cards and scatter plot update to show data only for those months.

Self Check

If you add a filter to show only months with advertising spend above $300, which components update and how?

• KPI Cards: Total Sales and Average Advertising Spend recalculate based on filtered months.
• Scatter Plot: Displays only points for months where advertising spend is above $300.

Key Result

Scatter plot dashboard showing how advertising spend relates to sales with KPIs for total sales and average spend.