How to Make a Scatter Plot in Excel (2026)
Scatter plots show the relationship between two numeric variables — perfect for correlation analysis, outlier detection, and exploring "does X predict Y?" This guide covers the build, adding a trendline, and labeling specific points.
⚡ Quick Answer
Two columns — X values, Y values. Select both with headers. Insert tab → Scatter icon → "Scatter with only markers". Add a trendline via right-click → Add Trendline.
Method: Basic scatter plot
Step 1: Set up your data
Two adjacent columns. X values in the first, Y values in the second. Optional headers.
Ad Spend Revenue
1,200 14,500
1,800 18,200
2,500 24,100
3,100 28,900
3,800 34,600
Step 2: Insert the chart
Select the range
Include headers and both columns.
Insert tab → Scatter icon
Dropdown shows: Scatter with markers, Scatter with smooth lines, Scatter with straight lines.
Pick "Scatter with only markers"
Each row becomes one point on the chart. This is the standard scatter plot.
Adding a trendline
Trendlines reveal patterns invisible in scattered points.
Right-click any data point → Add Trendline
Trendline panel opens on the right.
Choose trendline type
Linear (straight line — most common), Exponential (compound growth), Logarithmic (growth slowing), Polynomial (curved), Power, Moving Average.
Show equation and R-squared
Tick "Display Equation on chart" and "Display R-squared value on chart". Both help interpret the fit.
Format the line
Line style, color, dashed vs. solid. Dashed light gray is a clean choice.
R-squared measures how well the trendline fits the data. 1.0 = perfect fit; 0 = no relationship. Values above 0.7 suggest a strong linear relationship. Below 0.3, the trendline isn't meaningful.
Adding labels to specific points
Default scatter plots show just dots. To add point names:
Right-click a data point → Add Data Labels
Default labels appear (Y values).
Right-click labels → Format Data Labels
Panel opens.
Untick "Value"
Remove the default Y-value label.
Tick "Value from Cells"
Dialog asks you to select the range containing your labels.
Select your label range
Column with the names you want on each point. Click OK.
Position labels
Above, below, or auto. Excel's "Best Fit" avoids overlap.
Common scatter plot use cases
Correlation analysis
Ad spend vs. revenue. Points scattered upper-left to lower-right = negative correlation. Upper-right to lower-left = positive. Random cloud = no correlation.
Outlier detection
Points far from the main cluster stand out. Great for finding anomalies in datasets (unusual customer spend, product outliers).
Two-variable segmentation
Customer age vs. spend, split into visual quadrants. Points can be color-coded by category (adding a third variable via multiple series).
Before/after comparison
X = value before, Y = value after. Points above the diagonal = increased; below = decreased. Great for A/B tests.
Bubble charts (scatter with size)
A bubble chart is a scatter plot with a third dimension: bubble size. Data needs three columns (X, Y, Size).
Insert → Scatter icon → Bubble. Now each row is a bubble sized by the third column.
Scatter plot vs. line chart
Common confusion. Key difference:
- Line chart — connects points in row order. X-axis is ordinal (categories) or ordered (time).
- Scatter plot — plots each row independently. X-axis is numeric. No implied order between points.
If your X-axis is dates, both work — but scatter is more honest about the "each observation is separate" story. Line implies continuous change; scatter implies discrete observations.
Scatter plots show correlation, not causation. A strong upward trend between ad spend and revenue doesn't prove ads caused revenue — it could be seasonality, product launches, or other confounders. Interpret with judgment.
Explore relationships in your data
Scatter plots are perfect for exploratory analysis but require you to already suspect a relationship between two variables. Excel Wizard can suggest which columns correlate before you build the chart — "which two columns in this dataset correlate most strongly?" and it runs the analysis for you.
Install Excel Wizard →Frequently asked questions
How do I make a scatter plot in Excel?
Set up two numeric columns — X values in one, Y values in another. Select the range including headers. Insert tab → Scatter icon → pick 'Scatter with only markers'.
How do I add a trendline to a scatter plot?
Right-click any data point → Add Trendline. Choose Linear, Exponential, Logarithmic, or Polynomial based on shape. Tick 'Display equation' and 'Display R-squared' to see the math.
What's the difference between scatter and line charts?
Line charts connect points in the order they appear. Scatter plots show each point independently — no order, just the relationship between two variables. Use scatter for correlation, line for time series.
How do I add labels to scatter plot points?
Right-click a data point → Add Data Labels. Click labels → Format Data Labels → untick 'Value' → tick 'Value from cells' → select the range containing your labels.