Excel's scatter chart is the right chart type when both columns are numeric measurements. Here's how to build a clean XY plot, add a linear trendline, and show R² when you need a quick fit summary.
Method: XY Scatter Chart
Arrange your data in two columns
Put your X variable values in column A and Y variable values in column B. Add headers in row 1 (e.g., "Height" and "Weight"). Each subsequent row is one data point. Both columns must contain numbers only.
Select both data columns
Click the header of column A, then Shift+click the header of column B to select both columns. Including headers is fine — Excel will use them as axis labels.
Insert the Scatter chart
Go to Insert → Charts → Insert Scatter (X, Y) or Bubble Chart → Scatter. Choose the first option (dots only, no connecting lines). Excel inserts a scatter plot with your data.
Add axis titles
Click the chart. Go to Chart Design → Add Chart Element → Axis Titles → Primary Horizontal to add an X axis title. Repeat for Primary Vertical. Click each title and type your variable names.
Add a trend line
Right-click any dot → Add Trendline. In the Format Trendline panel, choose Linear for a straight-line relationship. Check Display R-squared value on chart if you want Excel to label the fitted line.
Improving your scatter plot
- Change dot color or size — right-click any dot → Format Data Series → Marker Options. Increase size to 8–10pt for readability; adjust fill color for your audience.
- Remove gridlines — click the gridlines and press Delete. A clean scatter plot usually only needs the axes, not both horizontal and vertical gridlines.
- Add data labels — if individual points need to be identified, right-click a dot → Add Data Labels. For more than a few points this becomes crowded; label only the points that need explanation.
- Force axes to start at zero — right-click the axis → Format Axis → Axis Options → Minimum: 0. Only do this if zero is a meaningful baseline for your data.
Multiple series on one scatter plot
To compare two groups (e.g., male and female students) on the same scatter plot, arrange the data in three columns: X, Series 1 Y, Series 2 Y. Select all three columns and insert a Scatter chart. Excel will plot two series with different colors automatically.
A note on R²
R² is the squared correlation for a simple linear fit, so it always sits between 0 and 1. A value near 1 means the fitted line explains much of the variation in Y; it does not prove causation, and it can still be misleading if the relationship is curved or driven by outliers. If you need the correlation coefficient itself, use Excel's CORREL() function.
Excel scatter plot limitations
- No built-in correlation coefficient label on the chart (only trendline R²)
- Styling is limited without VBA or Power BI
- Hard to annotate individual points interactively
When to use an online scatter plot maker instead
For quick exploration and clean exports — especially for reports or publications — the free online scatter plot maker lets you paste two-column data, control dot size and color, and export PNG or PDF without much setup.
FAQ
Why does Excel connect my scatter plot dots with lines?
If you see lines, you chose "Scatter with Smooth Lines" or "Scatter with Straight Lines" instead of plain "Scatter." Click the chart → Chart Design → Change Chart Type → select the plain Scatter option (dots only).
How do I add a correlation coefficient (R) to an Excel scatter plot?
Excel's trendline label can show R². To get R, calculate it manually: in an empty cell, enter =CORREL(A2:A100, B2:B100) and format to 3 decimal places. Add this as a text box on the chart.
Can I make a scatter plot in Excel with three variables?
Use a bubble chart: Insert → Charts → Insert Scatter or Bubble Chart → Bubble. The X position = variable 1, Y position = variable 2, bubble size = variable 3. You'll need three columns arranged as X, Y, Size.
References
How this guide is reviewed
This guide is maintained by the ChartsMakers Editorial Team and reviewed for statistical accuracy, product behavior, and clarity. Sources used for factual checks are listed in the References section. See our editorial policy.