Combo charts in Google Sheets - Dashboard Guide

Dashboard Mode - Combo charts

Dashboard Goal

See monthly sales and profit margin together to understand how profit changes with sales.

Sample Data

Month	Sales ($)	Profit ($)	Profit Margin (%)
Jan	1000	200	20
Feb	1500	300	20
Mar	1200	180	15
Apr	1700	340	20
May	1600	320	20
Jun	1800	360	20

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(B2:B7)
  Result: 8800
• KPI Card: Average Profit Margin
  Formula: =AVERAGE(D2:D7)
  Result: 19.17%
• Combo Chart: Monthly Sales and Profit Margin
  Setup:
  • X-axis: Month (A2:A7)
  • Series 1: Sales (B2:B7) as Column chart
  • Series 2: Profit Margin (D2:D7) as Line chart on secondary axis
  
  This chart shows sales as bars and profit margin as a line for each month.

Dashboard Layout

+----------------------+----------------------+
|   Total Sales (KPI)  | Avg Profit Margin (%) |
|        8800          |        19.17%        |
+----------------------+----------------------+
|                                              |
|          Combo Chart: Sales & Profit Margin  |
|                                              |
+----------------------------------------------+

Interactivity

Add a filter for Month to select specific months. When you pick months, the KPI cards and combo chart update to show data only for those months.

Self Check

If you filter to show only March and April, what is the Total Sales and Average Profit Margin shown? Which months appear in the combo chart?

Key Result

Dashboard showing monthly sales and profit margin with KPIs and a combo chart.