Chart elements (title, legend, axis labels) in Excel - Dashboard Guide

Dashboard Mode - Chart elements (title, legend, axis labels)

Dashboard Goal

Show monthly sales data with clear chart elements: title, legend, and axis labels to help understand sales trends.

Sample Data

Month	Sales
January	120
February	150
March	170
April	130
May	160
June	180

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(B2:B7)
  Result: 910
• Column Chart: Monthly Sales
  Data range: A2:B7
  Chart elements:
  • Title: "Monthly Sales Overview"
  • Legend: "Sales"
  • X-axis label: "Month"
  • Y-axis label: "Sales Amount"

Dashboard Layout

+---------------------------+
|       Monthly Sales       |
|        Overview           |
+---------------------------+
| Total Sales: 910          |
+---------------------------+
|  [Column Chart with       |
|   Months on X-axis and    |
|   Sales on Y-axis]        |
+---------------------------+

Interactivity

This dashboard is static for now. In Excel, you can add slicers or filters to select specific months or ranges, which will update the chart and total sales automatically.

Self Check

If you add a filter to show only sales from March to June, which components update?

• The Total Sales KPI card updates to sum only filtered months.
• The Column Chart updates to show bars only for March, April, May, and June.

Key Result

Monthly sales dashboard with total sales KPI and a column chart showing sales by month with clear chart elements.