An XY scatter graph is the chart you use when both of your columns are numbers and you want to know whether one moves with the other. Advertising spend against revenue. Hours studied against exam score. Risk against return. Excel makes one in about four clicks, and then hands you a chart with three default settings that quietly make it harder to read than it needs to be.
Here is the whole job: the layout the chart expects, the clicks, the settings worth changing, and the one chart type people pick by mistake.
Lay the data out first
An XY scatter plots one point per row, using two numeric columns:
| Risk (X) | Return (Y) |
|---|---|
| 0.9 | 3.4 |
| 2.1 | 5.2 |
| 3.6 | 6.1 |
| 5.4 | 8.8 |
Three rules for the range:
- X goes in the left column, Y in the column to its right. Excel reads the leftmost selected column as the horizontal axis. If your sheet has them the other way round, either move the column or fix it later in Select Data — but moving the column is faster.
- One row per observation. Do not pre-average or group. A scatter is a chart of individual cases, and summarizing them away is how a real relationship turns into four dots.
- Both columns must actually be numbers. Values imported as text sit left-aligned in the cell and plot as zero or not at all. If your numbers are hugging the left edge of the column, that is the bug.
Make the chart
- Select both columns, including the header row.
- Go to Insert → Charts, click the Insert Scatter (X, Y) or Bubble Chart icon, and choose the first option, Scatter.
- Excel drops a chart on the sheet. (Alt+F1 does the same thing with the default chart type, and F11 puts it on its own sheet.)
On Mac the ribbon is the same: Insert → Chart → X Y (Scatter).
If you have more than one series, do not select a third column and hope. Right-click the chart, choose Select Data → Add, then set Series X values and Series Y values by range for each series in turn. It is tedious and it is the only way that reliably gets you two series with different X values on one chart.
Fix the three defaults that hurt
The axes usually start in the wrong place. Excel picks bounds that leave your cloud of points floating in a corner. Click the axis, then Format Axis → Bounds, and set a minimum near your smallest value. Unlike a bar chart, a scatter does not have to start at zero — nothing about the encoding depends on it, and forcing zero often squeezes the whole pattern into a fifth of the plot area.
Nobody knows what the axes are. Click the chart, hit the + (Chart Elements) button, tick Axis Titles, and write the units in. "Ad spend ($000)" takes five seconds and saves every reader ten.
The markers are wrong for the number of points. With 20 points, make them bigger. With 2,000, make them smaller and add transparency — Format Data Series → Marker → Fill → Solid fill, then push transparency to 60 or 70 percent so density becomes visible instead of a single black blob.
While you are in Chart Elements, if you want the points labeled, tick Data Labels, then open Format Data Labels and choose Value From Cells to point at a column of names. This is the setting people search for most and find least: it is how you label points with a text column rather than with their own coordinates.
Add a trendline, carefully
Chart Elements (+) → Trendline → More Options gives you the fit types, plus two checkboxes worth ticking: Display Equation on chart and Display R-squared value on chart.
Two cautions that matter more than the clicks. A high R² tells you the line fits these points, not that X causes Y. And the Forecast boxes in the same panel will happily extend your line beyond the data — which is exactly where a fitted line is least trustworthy.
The mistake almost everyone makes
Picking Line instead of Scatter.
A line chart treats the first column as labels, not as numbers. It spaces them evenly along the axis regardless of their values, so measurements taken at 1, 2, 4 and 40 minutes appear at four equal steps. The shape it draws is not the shape of your data. If your X column is numeric and irregularly spaced — and it usually is — you want a scatter, and you can add connecting lines to it afterwards from Format Data Series → Line if you need them.
The rest of the usual list:
- Blank cells inside the range. Excel skips the row silently. Filter the blanks out before you chart.
- Too many points, all opaque. 5,000 identical markers is not a distribution, it is an inkblot. Transparency, smaller markers, or sample the data.
- A category on the X axis. Regions, months and product names are not numbers. That is a bar chart or a line chart, not a scatter.
- One outlier setting the scale. A single point at 40x the others flattens everything else against the axis. Either annotate it and keep it, or split it out and say why.
When Excel stops being the right tool
Excel is fine for looking. The trouble starts when the chart has to leave the workbook. What you can take out is a picture: a pasted image that cannot be hovered, that has to be regenerated by hand every time a number changes, and that carries Office's styling onto your page whether you like it or not.
If the scatter is going into a post, a report or a dashboard, build it somewhere designed for publishing. Our scatter plot maker takes the same two columns, gives every point a tooltip, lets you set your own fonts and colors, and hands you an embed snippet — or a clean SVG for print. Same data, one upload, and the chart stays live when the numbers change.
FAQ
What is the difference between a scatter chart and a line chart in Excel? A scatter chart plots X and Y as two numeric coordinates, so the horizontal spacing reflects the actual values. A line chart treats the first column as evenly spaced categories. If your X values are numbers with uneven gaps, the line chart will draw a shape your data does not have.
How do I add labels to each point in an Excel scatter plot? Select the series, tick Data Labels under Chart Elements, then open Format Data Labels and choose Value From Cells. Point it at the column holding your names. Untick X Value and Y Value unless you want the coordinates showing too.
Why is my scatter chart showing only one point, or none? Almost always because the values are stored as text rather than numbers, or because the selected range includes blank rows. Check the alignment in the cells: numbers sit right, text sits left.
Can I plot two data sets on one scatter chart? Yes. Right-click the chart, choose Select Data → Add, and set Series X values and Series Y values for each series separately. Give each one a name so the legend is useful.
Should the axes on a scatter plot start at zero? Not necessarily. Bar charts must start at zero because the bar's length is the encoding; on a scatter the position is what matters, so the axis should frame the data. Zoom in enough to see the pattern, and label the axes so nobody is misled about the range.
