Moving charts to separate sheets in Google Sheets - Dashboard Guide

Dashboard Mode - Moving charts to separate sheets

Dashboard Goal

Show sales trends and totals clearly by moving charts to separate sheets for better focus and presentation.

Sample Data

Month	Region	Sales
Jan	East	100
Jan	West	150
Feb	East	200
Feb	West	180
Mar	East	250
Mar	West	220

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(C2:C7)
  Result: 1100
• Table: Sales by Month and Region
  Shows raw data from A1:C7
• Chart Sheet: Line Chart showing Sales over Months by Region
  Created by selecting data A1:C7 and inserting a line chart on a new sheet named 'Sales Chart'

Dashboard Layout

+----------------------+------------------+
|      KPI Card        |    Data Table    |
|   (Total Sales)      |  (Sales Data)    |
+----------------------+------------------+

[Separate Sheet: 'Sales Chart']
+-----------------------------+
|       Line Chart            |
|  Sales by Month and Region  |
+-----------------------------+

Interactivity

Filters on the main sheet (like selecting a specific Region or Month) update the data table and KPI card instantly. The chart on the separate sheet updates automatically because it references the same filtered data range.

Self Check

If you add a filter to show only the 'East' region, which components update?

• KPI Card updates to show total sales for East only.
• Data Table shows only rows where Region is East.
• Chart on the separate sheet updates to show sales trends for East region only.

Key Result

Dashboard shows total sales and detailed sales data with a separate sheet for sales trend chart.