In Excel: put numeric x-values in one column and numeric y-values in the next, select both columns, then Insert ▸ Scatter (X, Y).
On this page7
Place x-values in the left column and y-values in the right column.
Select both numeric columns, without totals or labels inside the data body.
Choose Insert ▸ Scatter (X, Y) and pick markers or smooth lines.
Add axis titles and, when useful, a trendline with the equation or R-squared value.
What this does
A scatter plot compares two numeric measurements. Unlike a line chart, both axes are value axes, so the distance between points matters on x and y. It is the right chart for relationships, clusters, outliers and correlations: ad spend versus revenue, height versus weight, temperature versus demand. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “excel scatter chart multiple series”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected chart change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a visual that makes the number obvious at a glance useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Column A holds ad spend 100, 200, 300, 400 and 500; column B holds revenue 820, 980, 1210, 1320 and 1510. Select A2:B6 and insert a Scatter chart. The upward cloud shows revenue rising as spend rises. Add a trendline and display R-squared to quantify how closely the points follow a line. Scatter plots are the spreadsheet workhorse for relationship questions. They quickly reveal whether two measures move together, where outliers sit and whether a trendline is meaningful enough to discuss. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. The short version of “excel scatter chart multiple series”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.
Common mistakes
- Using a line chart, which treats the x-axis as categories instead of numeric positions.
- Selecting the y-values first, causing Excel to guess the x-axis incorrectly.
- Mixing text labels into the numeric range, which can make points disappear or plot at zero.
- Interpreting correlation as causation; a scatter plot shows association, not proof.
Frequently asked questions
What is the difference between scatter and line charts?
Scatter charts use numeric x and y axes. Line charts connect ordered categories or dates and are usually for trends over a sequence.
How do I add a trendline?
Click the series, choose Chart Elements (+) ▸ Trendline, and open More Options to show the equation or R-squared.
Can I label individual points?
Yes. Add data labels, then use label options to pull labels from a worksheet range.