Chart interactivity in Google Sheets - Dashboard Guide

Dashboard Mode - Chart interactivity

Dashboard Goal

See how sales change by product category and month. Use the dropdown to pick a category and watch the chart update.

Sample Data

Month	Category	Sales
Jan	Books	120
Jan	Electronics	200
Feb	Books	150
Feb	Electronics	220
Mar	Books	130
Mar	Electronics	210
Apr	Books	160
Apr	Electronics	230

Dashboard Components

• Dropdown filter: Cell E2 with data validation listing categories: Books, Electronics.
• Filtered sales table: Starting at cell G2, formula:
  =FILTER(A2:C9, B2:B9=E2)
  This shows only rows matching the selected category.
• Sales chart: A line chart based on the filtered table (G2:I9). It shows sales over months for the chosen category.

Dashboard Layout

+----------------------+---------------------+
| Dropdown filter (E2) | Sales Chart (G12)   |
+----------------------+---------------------+
| Filtered Sales Table (G2:I9)               |
+--------------------------------------------+

Interactivity

When you pick a category in the dropdown (E2), the FILTER formula updates the sales table below. The chart uses this filtered table as its data source, so it updates automatically to show sales only for the selected category.

Self Check

If you change the dropdown to "Books", which rows appear in the filtered table? What does the chart show?

Key Result

Interactive sales chart updates by product category selected from dropdown.