Pie charts in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This table shows types of fruit and their quantities. We want to create a pie chart to visualize the proportion of each fruit.

Cell	Value
A1	Fruit
B1	Quantity
A2	Apples
B2	30
A3	Bananas
B3	20
A4	Cherries
B4	50

Formula Trace

=B2:B4

Step 1: B2:B4

Cell Reference Map

    A       B
1 | Fruit | Quantity |
2 | Apples|   30    |
3 |Bananas|   20    |
4 |Cherries|  50    |

Arrows point from B2:B4 to the pie chart data source.

The pie chart uses the quantity values from cells B2 to B4 as its data source.

Result

Spreadsheet view:

    A       B
1 | Fruit | Quantity |
2 | Apples|   30    |
3 |Bananas|   20    |
4 |Cherries|  50    |

Pie chart shows 3 slices:
- Apples slice (30%)
- Bananas slice (20%)
- Cherries slice (50%)

The pie chart visually displays the proportion of each fruit quantity. Apples take 30% of the pie, Bananas 20%, and Cherries 50%.

Sheet Trace Quiz - 3 Questions

Which cells provide the data for the pie chart slices?

A A2:A4

B B2:B4

C A1:B1

D A1:B4

Key Result

Pie charts use a range of numeric values as data source to show proportional slices.