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

Scatter plots are one of the most useful chart types in Excel — and one of the most underused. Whether you're tracking the relationship between two variables, spotting outliers in a dataset, or visualizing trends across time, a scatter plot gives you a view that bar charts and line graphs simply can't. Here's exactly how to build one, plus what to know before you start.

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

A scatter plot (also called an XY chart) displays data points as individual dots on a two-axis grid. Each dot represents one row of data, plotted based on its X value (horizontal axis) and Y value (vertical axis). Unlike a line chart, there's no implied sequence — the chart cares about relationships, not order.

Use a scatter plot when you want to:

• See whether two variables are correlated (e.g., do higher ad spend figures relate to higher sales?)
• Identify clusters or outliers in a dataset
• Compare paired numerical values across multiple observations
• Visualize distribution patterns across a range

Scatter plots work best with purely numerical data on both axes. If one of your axes is categorical (months, names, product types), a bar or line chart is likely a better fit.

What You Need Before You Start

Your data needs to be organized in at least two columns of numerical values. Excel will treat the left column as the X axis and the right column as the Y axis by default. Make sure:

• Each row represents one data point
• Both columns contain numbers (not text or blank cells)
• Column headers are in the first row — Excel will use these as axis labels

This kind of clean, two-column layout is the foundation of a functional scatter plot.

Step-by-Step: Building a Scatter Plot in Excel 🗂️

Step 1: Select Your Data

Click on the first cell of your data range, then drag to select all rows and both columns, including the headers. If your data isn't in adjacent columns, hold Ctrl and click each column separately.

Step 2: Insert the Chart

Go to the Insert tab in the Excel ribbon. In the Charts group, click the Insert Scatter (X, Y) or Bubble Chart icon — it looks like a small grid of dots. From the dropdown, choose Scatter (the first option, with no connecting lines).

Excel will immediately generate a basic scatter plot based on your selected data.

Step 3: Label Your Axes

A scatter plot without labeled axes is nearly meaningless to anyone else reading it. To add labels:

1. Click the chart to select it
2. Click the Chart Elements button (the + icon on the right side of the chart)
3. Check Axis Titles
4. Click each axis title placeholder and type your label

Axis labels should describe the variable and the unit of measurement where applicable (e.g., "Monthly Revenue (USD)").

Step 4: Add a Chart Title

The chart title placeholder appears at the top of your chart by default. Click it and replace the generic text with something descriptive and specific — something that tells a reader exactly what relationship the chart is showing.

Step 5: Customize Your Chart (Optional but Useful)

Excel gives you several ways to refine the look and functionality of your scatter plot:

• Add a trendline: Right-click any data point → Add Trendline. Choose Linear for a straight correlation line, or Exponential/Polynomial for curved trends. You can also display the R² value on the chart to indicate how well the trendline fits the data.
• Change data point colors or shapes: Right-click a data point → Format Data Series to adjust marker style, size, and color.
• Add data labels: Through Chart Elements → Data Labels, you can show the X or Y value next to each point. This is useful for smaller datasets where individual points need identification.
• Adjust axis scale: If your data clusters in a narrow range, right-click an axis → Format Axis → manually set the minimum and maximum values to zoom in.

Working With Multiple Data Series 📊

If you want to compare two groups on the same scatter plot (e.g., sales data from two different regions), you can add a second data series:

1. Click the chart to select it
2. Right-click → Select Data
3. Click Add under Legend Entries
4. Define the X and Y value ranges for the new series

Each series will appear in a different color by default, and Excel will auto-generate a legend. You can rename each series in the Select Data Source dialog to keep the chart readable.

The Factors That Change Your Results

The steps above are consistent across modern Excel versions, but a few variables affect how your scatter plot looks and performs:

• Excel version: Excel 2016 and later offer more chart customization options than older versions. Microsoft 365 users get the most up-to-date chart tools and may see slightly different menu layouts.
• Dataset size: Scatter plots with hundreds of data points can get visually dense quickly. Transparency settings, smaller marker sizes, or filtering the data first can help.
• Data range and outliers: A single extreme outlier can compress the rest of your chart into an unreadable cluster. Adjusting the axis scale — or addressing the outlier directly — changes how the relationship reads visually.
• Trendline choice: The right trendline type depends entirely on the nature of your data. Applying a linear trendline to exponentially distributed data gives a misleading picture.

What the Chart Shows Versus What It Proves

One thing worth keeping in mind: a scatter plot reveals correlation, not causation. Two variables moving together doesn't mean one is driving the other. How you interpret the chart — and how confidently you act on it — depends on the context of your data, your domain knowledge, and whether there are other variables at play that the chart doesn't capture.

The steps to build the chart are the same for everyone. What the chart means, and what you do with it, is entirely specific to your data and your situation.