Title, labels, and legends in Power BI - Cell-by-Cell Formula Trace

Sample Data

Monthly sales data for the first quarter

Cell	Value
A1	Month
B1	Sales
A2	Jan
B2	100
A3	Feb
B3	150
A4	Mar
B4	120

Formula Trace

Add chart title 'Quarter 1 Sales', X-axis label 'Month', Y-axis label 'Sales', and legend for Sales series

Step 1: Select chart visual

Step 2: Add chart title 'Quarter 1 Sales'

Step 3: Set X-axis label to 'Month'

Step 4: Set Y-axis label to 'Sales'

Step 5: Enable legend for Sales series

Cell Reference Map

    A       B
1 | Month | Sales |
2 |  Jan  |  100  |
3 |  Feb  |  150  |
4 |  Mar  |  120  |

Arrows:
B column feeds Sales data into chart
A column feeds Month labels into chart

The chart uses column A for X-axis labels (Month) and column B for Y-axis values (Sales)

Result

Chart: Quarter 1 Sales

Legend: Sales

X-axis: Month (Jan, Feb, Mar)
Y-axis: Sales (100, 150, 120)

[Bar chart with 3 bars labeled Jan, Feb, Mar with heights 100, 150, 120]

The chart shows monthly sales with a clear title, axis labels, and a legend identifying the Sales data series

Sheet Trace Quiz - 3 Questions

What does the chart title 'Quarter 1 Sales' describe?

A The label for the Y-axis

B The label for the X-axis

C The overall topic of the chart

D The name of the legend

Key Result

Add descriptive titles, axis labels, and legends to charts for clarity