How to Create a Scatter Plot in Excel: A Step-by-Step Guide

Scatter plots are one of the most useful chart types in Excel for visualizing relationships between two variables. Whether you're tracking sales against advertising spend, mapping test scores against study hours, or comparing any two numeric datasets, a scatter plot makes patterns, correlations, and outliers immediately visible. Here's exactly how to build one — and what to consider when customizing it for your data.

What Is a Scatter Plot and When Should You Use One?

A scatter plot (also called an XY chart) plots individual data points on a two-axis grid. Each point represents a pair of values — one from your X-axis variable and one from your Y-axis variable. Unlike a line chart, scatter plots don't connect data chronologically or sequentially. They show distribution and correlation.

Use a scatter plot when:

• You want to see whether two numeric variables are related
• You're looking for clusters, gaps, or outliers in a dataset
• You have a large number of data points that would be unreadable in a bar or line chart

Scatter plots work best with continuous numeric data on both axes. They're less useful when one of your variables is categorical (like names or labels).

Preparing Your Data in Excel

Before inserting a chart, your data needs to be structured correctly. Excel's scatter plot tool expects:

• Two columns of numeric data side by side
• The X-axis values in the left column, Y-axis values in the right
• A header row at the top of each column (optional but recommended for axis labels)

If your data has more than two columns, Excel will try to plot each additional column as a separate data series — which can be useful for comparison, but it's worth understanding before you select your range.

How to Insert a Scatter Plot 📊

1. Select your data range — click and drag to highlight both columns, including headers if you have them.
2. Go to the Insert tab on the ribbon.
3. In the Charts group, click the Insert Scatter (X, Y) or Bubble Chart button — it looks like a small cluster of dots.
4. From the dropdown, select Scatter (the plain dot version, no lines).

Excel will immediately generate a basic scatter plot using your selected data. The X-axis will pull from your left column and the Y-axis from your right.

Choosing the Right Scatter Plot Subtype

Excel offers five scatter plot subtypes under that same dropdown:

For most analytical purposes, the basic Scatter (dots only) version is the clearest starting point. Lines can imply relationships between consecutive points that may not actually exist.

Customizing Your Scatter Plot

Once the chart is inserted, Excel gives you significant control over its appearance and function.

Adding Axis Titles

Click the chart, then select the + (Chart Elements) button that appears to the upper right. Check Axis Titles to add labels. Double-click each title to rename it to something meaningful — "Monthly Revenue ($)" is more useful than "Axis 1."

Adding a Trendline

A trendline draws a best-fit line through your data points, making correlation easier to spot visually.

1. Click any data point in your chart
2. Right-click and choose Add Trendline
3. In the Format Trendline panel, choose Linear for straightforward correlation, or Exponential/Polynomial if your data curves

You can also check Display R-squared value on chart — this gives you a quick statistical indicator of how well the trendline fits your data. An R² value closer to 1.0 indicates a stronger fit.

Formatting Data Points

Right-click any data point and select Format Data Series to change:

• Marker shape and size — useful when differentiating multiple series
• Fill and border color — important for accessibility and readability
• Transparency — helpful when you have many overlapping points

Working With Multiple Data Series

If you're comparing two groups on the same chart, you can plot multiple series. After inserting a basic chart, right-click the chart area and choose Select Data. From there, use Add to introduce a new series with its own X and Y ranges.

Each series gets its own color by default, and you can add a legend via the Chart Elements menu to label them clearly. This is particularly useful when comparing control vs. experimental groups, or different time periods.

Variables That Affect How Useful Your Scatter Plot Is

Not every scatter plot tells a clear story — and several factors determine how readable and accurate yours will be:

• Dataset size: Small datasets (under 20 points) may not reveal meaningful patterns; very large datasets may need color-coding or filtering to stay readable
• Data range: If your X or Y values span wildly different magnitudes, consider a logarithmic scale (available in axis formatting options)
• Outliers: A single extreme value can compress the rest of your chart — decide whether to include, exclude, or annotate them
• Excel version: Formatting options and chart styles vary between Excel 2016, 2019, Microsoft 365, and Excel for Mac

The same two-variable dataset can look very different — and tell a very different story — depending on axis scaling, trendline choice, and how outliers are handled. 🔍

One Thing Worth Thinking About

The steps above cover the mechanics cleanly. But what makes a scatter plot useful — clear axis labels, the right scale, whether a trendline is appropriate, how to handle messy real-world data — depends entirely on what your dataset looks like and what question you're trying to answer. Those choices don't have a universal right answer. They follow from the data itself.