Sparklines (LINE, BAR, COLUMN) in Google Sheets - Dashboard Guide

Dashboard Mode - Sparklines (LINE, BAR, COLUMN)

Dashboard Goal

Show quick visual trends of monthly sales for each product using sparklines in Google Sheets.

Sample Data

Product	Jan	Feb	Mar	Apr	May
Apples	120	135	150	160	170
Bananas	80	90	100	110	115
Cherries	60	65	70	75	80
Dates	40	45	50	55	60
Elderberries	30	35	40	45	50

Dashboard Components

• Sales Data Table: Shows monthly sales for each product (A2:F6).
• Line Sparkline Column (G2:G6): Formula in G2: =SPARKLINE(B2:F2, {"charttype","line"}) copied down to G6. Shows sales trend as a line.
• Bar Sparkline Column (H2:H6): Formula in H2: =SPARKLINE(B2:F2, {"charttype","bar"}) copied down to H6. Shows sales as horizontal bars.
• Column Sparkline Column (I2:I6): Formula in I2: =SPARKLINE(B2:F2, {"charttype","column"}) copied down to I6. Shows sales as vertical bars.

Dashboard Layout

+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+
| Product        | Jan            | Feb            | Mar            | Apr            | May            | Line Sparkline | Bar Sparkline  | Column Sparkline|
+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+
| Apples         | 120            | 135            | 150            | 160            | 170            | (G2)           | (H2)           | (I2)           |
| Bananas        | 80             | 90             | 100            | 110            | 115            | (G3)           | (H3)           | (I3)           |
| Cherries       | 60             | 65             | 70             | 75             | 80             | (G4)           | (H4)           | (I4)           |
| Dates          | 40             | 45             | 50             | 55             | 60             | (G5)           | (H5)           | (I5)           |
| Elderberries   | 30             | 35             | 40             | 45             | 50             | (G6)           | (H6)           | (I6)           |
+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+

Interactivity

Add a filter dropdown for Product names above the table. When a product is selected, only that product's row and its sparklines show. This helps focus on one product's sales trend at a time.

Self Check

If you add a filter to show only "Bananas", which rows and sparklines remain visible? Answer: Only the row for Bananas and its sparklines in columns G, H, and I remain visible.

Key Result

Dashboard shows monthly sales trends for products using line, bar, and column sparklines side by side.