How to Make a Scatter Plot in Excel (2026 Guide)
Home›Excel Charts›Make a Scatter Plot
ExcelHow-To⏱ 2 min read

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

  1. Select the range

    Include headers and both columns.

  2. Insert tab → Scatter icon

    Dropdown shows: Scatter with markers, Scatter with smooth lines, Scatter with straight lines.

  3. 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.

  1. Right-click any data point → Add Trendline

    Trendline panel opens on the right.

  2. Choose trendline type

    Linear (straight line — most common), Exponential (compound growth), Logarithmic (growth slowing), Polynomial (curved), Power, Moving Average.

  3. Show equation and R-squared

    Tick "Display Equation on chart" and "Display R-squared value on chart". Both help interpret the fit.

  4. Format the line

    Line style, color, dashed vs. solid. Dashed light gray is a clean choice.

What R-squared tells you

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:

  1. Right-click a data point → Add Data Labels

    Default labels appear (Y values).

  2. Right-click labels → Format Data Labels

    Panel opens.

  3. Untick "Value"

    Remove the default Y-value label.

  4. Tick "Value from Cells"

    Dialog asks you to select the range containing your labels.

  5. Select your label range

    Column with the names you want on each point. Click OK.

  6. 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.

Don't confuse trendline slope with causation

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.

Excel Wizard

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.