Pie and doughnut charts in Excel - Cell-by-Cell Formula Trace

Sample Data

This data shows different fruits and their quantities. It is used to create pie and doughnut charts that visually represent the parts of the whole.

Cell	Value
A1	Fruit
B1	Quantity
A2	Apples
B2	30
A3	Bananas
B3	20
A4	Cherries
B4	10
A5	Dates
B5	40

Formula Trace

=SUM(B2:B5)

Step 1: SUM(30, 20, 10, 40)

Cell Reference Map

    A       B
1 | Fruit | Quantity |
2 | Apples|   30    |
3 |Bananas|   20    |
4 |Cherries|  10    |
5 | Dates |   40    |

Arrows: B2 -> SUM, B3 -> SUM, B4 -> SUM, B5 -> SUM

Cells B2 to B5 contain the quantities of fruits. These cells are referenced by the SUM formula to calculate the total quantity.

Result

    A       B       C
1 | Fruit | Quantity | Total |
2 | Apples|   30    |  100  |
3 |Bananas|   20    |       |
4 |Cherries|  10    |       |
5 | Dates |   40    |       |

The total quantity 100 is shown in cell C2 as the result of the SUM formula. This total is used to understand the whole for pie or doughnut charts.

Sheet Trace Quiz - 3 Questions

What does the formula =SUM(B2:B5) calculate?

A The average quantity of fruits

B The quantity of Apples only

C The total quantity of all fruits

D The difference between Dates and Bananas

Key Result

SUM(range) adds all numbers in the specified range to find the total.