Scatter plots in Google Sheets - Step-by-Step Guide

Introduction

Scatter plots help you see how two sets of numbers relate to each other. They show dots on a grid where each dot represents a pair of values. This is useful to find patterns or trends in your data.

When you want to check if sales increase as advertising spend goes up.

When you want to compare students' test scores in math and reading.

When you want to see if temperature affects ice cream sales.

When you want to find out if taller people tend to weigh more.

When you want to spot any unusual data points that do not fit the pattern.

Steps

Step 1: Select

- the two columns of data you want to compare

The cells with your data are highlighted on the sheet

Step 2: Click

- Insert menu at the top

A dropdown menu appears with chart options

Step 3: Choose

- Chart from the Insert menu

A chart appears on your sheet and the Chart editor panel opens on the right

Step 4: In the Chart editor panel, click

- Setup tab, then Chart type dropdown

A list of chart types appears

Step 5: Scroll and select

- Scatter chart from the list

The chart changes to a scatter plot showing your data points

Step 6: Use

- Customize tab in the Chart editor

You can change colors, add axis titles, and adjust point size to make the chart clearer

Before vs After

Before

Two columns of numbers with no visual summary, for example, Advertising Spend and Sales figures in columns A and B

After

A scatter plot chart appears showing dots where each dot's position matches the Advertising Spend (horizontal) and Sales (vertical) values

Settings Reference

Chart type

📍 Chart editor panel > Setup tab > Chart type dropdown

Choose the type of chart to display your data

Default: Column chart

Horizontal axis title

📍 Chart editor panel > Customize tab > Chart & axis titles > Horizontal axis title

Label the bottom axis to explain what data it shows

Default: None

Vertical axis title

📍 Chart editor panel > Customize tab > Chart & axis titles > Vertical axis title

Label the side axis to explain what data it shows

Default: None

Point size

📍 Chart editor panel > Customize tab > Series > Point size

Change how big the dots appear on the scatter plot

Default: Medium

Common Mistakes

Selecting only one column of data before inserting the chart

Scatter plots need two sets of numbers to compare, so one column is not enough

Select both columns of data that you want to plot before inserting the chart

Choosing the wrong chart type like a line or column chart

These charts do not show the relationship between two numeric sets as clearly as scatter plots

Always pick Scatter chart from the Chart type dropdown for this purpose

Not labeling the axes

Without axis titles, it is hard to understand what the dots represent

Add clear horizontal and vertical axis titles in the Customize tab

Summary

Scatter plots show how two sets of numbers relate by plotting dots on a grid.

You create them by selecting two columns of data and choosing Scatter chart from the Insert > Chart menu.

Remember to label your axes so others can understand what the chart shows.

Practice

1. What does a scatter plot primarily show in Google Sheets?

easy

A. The relationship between two sets of numbers

B. The total sum of a data column

C. The average value of a dataset

D. The frequency of a single number

Solution

1. Step 1: Understand scatter plot purpose

   A scatter plot displays points representing pairs of values from two data sets.

2. Step 2: Identify what it shows

   It shows how two variables relate or if there's a pattern between them.

3. Final Answer:

   The relationship between two sets of numbers -> Option A

4. Quick Check:

   Scatter plot = relationship between two data sets [OK]

Hint: Scatter plots compare two data sets visually [OK]

Common Mistakes:

• Thinking it shows totals or averages
• Confusing with bar or pie charts
• Assuming it shows frequency counts

2. Which menu option do you use in Google Sheets to insert a scatter plot?

easy

A. Tools > Script editor

B. Data > Pivot table

C. Format > Conditional formatting

D. Insert > Chart

Solution

1. Step 1: Locate chart insertion

   Scatter plots are created by inserting a chart from the Insert menu.

2. Step 2: Choose correct menu path

   Insert > Chart opens chart options including scatter plot type.

3. Final Answer:

   Insert > Chart -> Option D

4. Quick Check:

   Insert menu > Chart for scatter plots [OK]

Hint: Insert menu always has chart options [OK]

Common Mistakes:

• Choosing Data or Format menus instead
• Looking for scatter plot outside Insert menu
• Confusing with script editor tools

3. Given data in columns A and B, what will the scatter plot show if column A has values 1, 2, 3 and column B has values 2, 4, 6?

medium

A. A horizontal line at value 3

B. Points forming a straight line showing a doubling pattern

C. Random scattered points with no pattern

D. A vertical line at value 2

Solution

1. Step 1: Analyze data pairs

   Pairs are (1,2), (2,4), (3,6) showing B is double A.

2. Step 2: Understand scatter plot pattern

   Points will align on a straight line with slope 2, showing doubling.

3. Final Answer:

   Points forming a straight line showing a doubling pattern -> Option B

4. Quick Check:

   Scatter plot shows linear doubling pattern [OK]

Hint: Look for simple numeric relationships in pairs [OK]

Common Mistakes:

• Assuming points are random
• Confusing line directions
• Thinking it forms horizontal or vertical lines

4. You created a scatter plot but it shows all points in a straight vertical line. What is the most likely cause?

medium

A. Y data column has identical values, X varies

B. Both X and Y data columns have the same values

C. X data column has identical values, Y varies

D. Data contains text instead of numbers

Solution

1. Step 1: Understand vertical line in scatter plot

   A vertical line means all X values are the same, Y values differ.

2. Step 2: Identify cause from options

   X data column has identical values, Y varies states X data identical, Y varies, matching the vertical line cause.

3. Final Answer:

   X data column has identical values, Y varies -> Option C

4. Quick Check:

   Vertical line = same X values [OK]

Hint: Vertical line means X values don't change [OK]

Common Mistakes:

• Thinking identical Y values cause vertical line
• Assuming text data causes vertical line
• Confusing vertical with horizontal line causes

5. You want to compare sales and advertising spend for 12 months using a scatter plot in Google Sheets. Which steps correctly create this scatter plot?

hard

A. Select sales and advertising columns, then Insert > Chart, choose Scatter chart type

B. Select sales column only, then Insert > Chart, choose Scatter chart type

C. Select advertising column only, then Insert > Chart, choose Line chart type

D. Select sales and advertising columns, then Insert > Chart, choose Pie chart type

Solution

1. Step 1: Select both data columns

   Scatter plots need two sets of data to compare, so select sales and advertising columns.

2. Step 2: Insert scatter chart

   Go to Insert > Chart and choose Scatter chart type to plot the relationship.

3. Final Answer:

   Select sales and advertising columns, then Insert > Chart, choose Scatter chart type -> Option A

4. Quick Check:

   Select two columns + Scatter chart = correct plot [OK]

Hint: Always select both data sets before inserting scatter chart [OK]

Common Mistakes:

• Selecting only one column
• Choosing wrong chart type like pie or line
• Not selecting data before inserting chart