Chart customization (title, legend, colors) in Google Sheets - Dashboard Guide

Dashboard Mode - Chart customization (title, legend, colors)

Dashboard Goal

Show monthly sales data with a clear chart that has a custom title, legend, and colors to make it easy to understand.

Sample Data

Month	Product A	Product B
January	120	90
February	150	110
March	170	130
April	160	120
May	180	140
June	200	150

Dashboard Components

• KPI Card: Total Sales for Product A
  Formula: =SUM(B2:B7)
  Result: 980
• KPI Card: Total Sales for Product B
  Formula: =SUM(C2:C7)
  Result: 740
• Line Chart: Monthly sales for Product A and Product B
  Data range: A1:C7
  Customizations:
  • Chart title: "Monthly Sales for Products A & B"
  • Legend position: Bottom
  • Colors: Product A line in blue (#1f77b4), Product B line in orange (#ff7f0e)

Dashboard Layout

+-----------------------------+
| Monthly Sales for Products A |
| & B (Line Chart)             |
|                             |
|                             |
|                             |
+-------------+---------------+
| Total Sales | Total Sales   |
| Product A   | Product B     |
| 980         | 740           |
+-------------+---------------+

Interactivity

Add a filter for Month (January to June). When you select a month, the line chart updates to show only that month's data, and the KPI cards update to show total sales for that month only.

Self Check

If you add a filter to show only March and April, which components update and what are their new values?

• Line Chart: Shows sales lines only for March and April.
• Total Sales Product A: =SUM(B4:B5) = 170 + 160 = 330
• Total Sales Product B: =SUM(C4:C5) = 130 + 120 = 250

Key Result

A line chart with custom title, legend, and colors showing monthly sales for two products, plus KPI cards for total sales.