Why advanced charts tell deeper stories in Google Sheets - Dashboard Impact

Dashboard Mode - Why advanced charts tell deeper stories

Dashboard Goal

Understand how advanced charts help reveal deeper insights from sales data across regions and products.

Sample Data

Region	Product	Month	Sales	Profit
East	Widget	Jan	120	30
East	Gadget	Jan	150	45
West	Widget	Jan	100	25
West	Gadget	Jan	130	40
East	Widget	Feb	140	35
East	Gadget	Feb	160	50
West	Widget	Feb	110	28
West	Gadget	Feb	135	42

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(D2:D9)
  Result: 1045
• KPI Card: Average Profit
  Formula: =AVERAGE(E2:E9)
  Result: 36.875
• Line Chart: Monthly Sales Trend by Region
  Data range: Region, Month, Sales
  Shows sales changes over Jan and Feb for East and West regions.
• Stacked Bar Chart: Sales by Product and Region
  Data range: Product, Region, Sales
  Shows how each product contributes to sales in each region.
• Pivot Table: Profit by Region and Product
  Rows: Region
  Columns: Product
  Values: SUM of Profit
  Formula: Use Google Sheets Pivot Table feature with data range A1:E9

Dashboard Layout

+----------------------+-----------------------+
| Total Sales (KPI)    | Average Profit (KPI)  |
+----------------------+-----------------------+
|                      |                       |
|  Line Chart: Monthly Sales Trend by Region    |
|                      |                       |
+-----------------------------------------------+
|       Stacked Bar Chart: Sales by Product & Region      |
+---------------------------------------------------------+
|           Pivot Table: Profit by Region and Product      |
+---------------------------------------------------------+

Interactivity

Add a filter for Region. Selecting a region updates the line chart, stacked bar chart, and pivot table to show data only for that region. The KPI cards also update to reflect total sales and average profit for the selected region.

Self Check

If you add a filter for Product = Widget, which components update?

• The KPI cards update to show total sales and average profit for Widget only.
• The line chart updates to show monthly sales trend for Widget by region.
• The stacked bar chart updates to show sales by region for Widget only.
• The pivot table updates to show profit by region for Widget only.

Key Result

Dashboard showing how advanced charts reveal sales and profit insights by region, product, and month.