Line charts in Excel - Dashboard Guide

Dashboard Mode - Line charts

Dashboard Goal

Show monthly sales trends for two products to compare their performance over the first half of the year.

Sample Data

Month	Product A Sales	Product B Sales
Jan	120	100
Feb	135	115
Mar	150	130
Apr	160	140
May	170	155
Jun	180	165

Dashboard Components

• KPI Card 1: Total Sales Product A
  Formula: =SUM(B2:B7)
  Result: 915
• KPI Card 2: Total Sales Product B
  Formula: =SUM(C2:C7)
  Result: 805
• Line Chart: Monthly Sales Trend
  Data Range: A1:C7
  Description: Shows sales for Product A and Product B from January to June. The X-axis is Month, Y-axis is Sales.

Dashboard Layout

+----------------------+----------------------+
|  KPI: Total Sales A  |  KPI: Total Sales B  |
+----------------------+----------------------+
|                                              |
|          Line Chart: Monthly Sales Trend      |
|                                              |
+----------------------------------------------+

Interactivity

Add a filter for Month (e.g., select only Jan to Mar). When the filter is applied:

• KPI cards update to show total sales only for selected months.
• Line chart updates to show sales trend only for selected months.

Self Check

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

• KPI Card 1: =SUM(B5:B7) = 160 + 170 + 180 = 510
• KPI Card 2: =SUM(C5:C7) = 140 + 155 + 165 = 460
• Line Chart: Shows sales data only for Apr, May, and Jun.

Key Result

Dashboard shows monthly sales trends and total sales for Product A and Product B from January to June.