Pie and donut charts in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data by fruit category showing total sales amounts.

Cell	Value
A1	Category
B1	Sales
A2	Apples
B2	120
A3	Bananas
B3	80
A4	Cherries
B4	100
A5	Dates
B5	50

Formula Trace

SUM(B2:B5)

Step 1: SUM(120, 80, 100, 50)

Cell Reference Map

   A       B
1 Category Sales
2 Apples   120
3 Bananas  80
4 Cherries 100
5 Dates    50

Arrows: SUM uses B2, B3, B4, B5 values

The formula sums the sales values in cells B2 through B5.

Result

   A       B       C
1 Category Sales   Total Sales
2 Apples   120    350
3 Bananas  80
4 Cherries 100
5 Dates    50

Pie chart slices represent each category's sales proportion of 350 total.

The total sales value 350 is used to calculate each slice size in the pie or donut chart.

Sheet Trace Quiz - 3 Questions

What is the total sales value calculated by the formula?

A 350

B 300

C 400

D 250

Key Result

SUM(range) adds all numeric values in the specified cell range.