Scatter plots in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This data shows heights in centimeters and weights in kilograms for 5 people.

Cell	Value
A1	Height (cm)
B1	Weight (kg)
A2	150
B2	50
A3	160
B3	60
A4	170
B4	65
A5	180
B5	70
A6	190
B6	80

Formula Trace

Insert > Chart > Chart type: Scatter chart

Step 1: Select data range A1:B6

Step 2: Insert > Chart

Step 3: Chart editor > Setup > Chart type: Scatter chart

Step 4: X-axis: Height (cm), Y-axis: Weight (kg)

Step 5: Chart displays points: (150,50), (160,60), (170,65), (180,70), (190,80)

Cell Reference Map

    A       B
1 Height  Weight
2  150      50
3  160      60
4  170      65
5  180      70
6  190      80

Data range A1:B6 is selected for the scatter plot.

The scatter plot uses the data from columns A and B, rows 1 to 6.

Result

Scatter Plot:

Y-axis (Weight)
|
|        *
|       *
|      *
|     *
|    *
|____________________
     X-axis (Height)

Points represent each person's height and weight.

The scatter plot shows points rising diagonally, indicating that weight tends to increase with height.

Sheet Trace Quiz - 3 Questions

Which column is used for the X-axis in the scatter plot?

A Height (cm)

B Weight (kg)

C Both Height and Weight

D Neither column

Key Result

Scatter plots use two columns of numeric data: one for X-axis and one for Y-axis to show relationships.