Featured Article

" Plot Your Data: Step-by-Step Guide to Creating Scatter Plots

Cynthia Jul 13, 2026

A scatter plot is a type of plot used in analytic geometry where data points are plotted on a two-dimensional coordinate system, allowing viewers to understand the relationship between two numerical variables. It's an effective tool for exploring relationships and trends in data. So, how do you actually create one? Let's dive in and learn step-by-step.

11 Hands-On Scatter Plot Activities (Free PDF Downloads)
11 Hands-On Scatter Plot Activities (Free PDF Downloads)

Whether you're a seasoned data analyst or just starting out, understanding how to graph a scatter plot is a crucial skill. These plots are used in various fields, from statistics and finance to physics and engineering. With the right software and a few key steps, you can create engaging and insightful visualizations.

Learn How to Create a Scatter Plot in Google Sheets
Learn How to Create a Scatter Plot in Google Sheets

Preparing Your Data

Before you can create a scatter plot, you need to organize your data. Ensure you have two distinct sets of numerical data - one for the x-axis and one for the y-axis. This could be a dataset of heights and weights, salaries and years of experience, or any other pair of related numerical values.

Scatter Plot Project with Real World Sports Data
Scatter Plot Project with Real World Sports Data

For example, you might have a dataset of car speeds and braking distances. To create a scatter plot, you'd need to pull out these two columns of data to use as the axis points.

Choosing Your Software

Scatter plots  Algebra Notes | Karen Jisan|
Scatter plots Algebra Notes | Karen Jisan|

There are various software tools you can use to create a scatter plot, each with its own strengths and learning curves. Some popular options include:

  • Excel: Easy to use, especially for smaller datasets, with built-in scatter plot functionality.
  • R: A powerful programming language for statistical computing and graphics.
  • Python (with libraries like matplotlib or seaborn): Flexible and great for larger datasets and more complex visualizations.
  • Tableau or Power BI: User-friendly visualization tools that can connect to various data sources.

With Excel

a poster on the wall that says scatterplots and points are placed to show the line of best fit
a poster on the wall that says scatterplots and points are placed to show the line of best fit

To create a scatter plot in Excel, follow these steps:

  1. Select your data range.
  2. Go to the 'Insert' tab and click on 'Scatter (X, Y)'.
  3. Choose the type of scatter plot you want (smooth, straight, or smooth with markers).
  4. Format your plot as desired.

With Python (using matplotlib)

Episode 17: 3 Ways to Amp-Up Your Scatter Plot! Featured Data Viz by Maarten Lambrechts — Data Viz Today
Episode 17: 3 Ways to Amp-Up Your Scatter Plot! Featured Data Viz by Maarten Lambrechts — Data Viz Today

Here's a simple Python code snippet to create a scatter plot using matplotlib:

import matplotlib.pyplot as plt

x = [....]  # your x-axis data
y = [....]  # your y-axis data

plt.plot(x, y, 'o')  # 'o' adds a scatter plot instead of a line plot
plt.xlabel('X-axis label')
plt.ylabel('Y-axis label')
plt.title('Title of your plot')
plt.show()

four different types of graphing are shown in the diagram, and each has two points on
four different types of graphing are shown in the diagram, and each has two points on
Scatter Plots, Lines of Best Fit and TI-84 Tips
Scatter Plots, Lines of Best Fit and TI-84 Tips
Scatterplot Line of Best Fit Anchor Chart
Scatterplot Line of Best Fit Anchor Chart
How to Make a Scatter Plot in Excel and Present Your Data
How to Make a Scatter Plot in Excel and Present Your Data
an open notebook with writing on it and a graph in the middle that says scatter plots
an open notebook with writing on it and a graph in the middle that says scatter plots
Scatter Plots and Line of Best Fit Worksheets
Scatter Plots and Line of Best Fit Worksheets
Excel Scatter Plot Tutorial | Step-by-Step Data Visualization Guide for Beginners
Excel Scatter Plot Tutorial | Step-by-Step Data Visualization Guide for Beginners
Scatter Plots & Correlation
Scatter Plots & Correlation
Cup Stacking Design Challenge with Scatterplot Graphs TEKS 5.9B and 5.9C Google
Cup Stacking Design Challenge with Scatterplot Graphs TEKS 5.9B and 5.9C Google