To make an Excel X Y scatter plot with multiple series, insert a Scatter chart, then use Chart Design > Select Data > Add to assign each series its own X-values and Y-values ranges. This method works in Excel for Microsoft 365 on Windows and lets you compare datasets even when their X-values differ.
What an X Y scatter chart shows
A scatter chart plots each observation as a point using two numeric values: one for the horizontal X-axis and one for the vertical Y-axis. A series is a related group of points, such as measurements from one location, product, experiment, or time period. Adding several series makes it possible to compare groups on the same set of axes.
For example, imagine comparing the relationship between hours of practice and test scores for three classes. Each class is a separate series. Its X-values are the practice hours, and its Y-values are the scores. Excel plots each matched pair as a point, so a point at X = 4 and Y = 82 represents a student who practiced for four hours and scored 82.
Unlike a line chart, a scatter chart treats the horizontal values as numbers and positions points according to their numeric spacing. A point at X = 10 is twice as far from zero as a point at X = 5. This makes a scatter chart a good choice when the X-values are measurements, dates, or other quantities where the distance between values matters.
Arrange the data for multiple series
Give every series a clear name and keep each X value beside the Y value it belongs with. A shared-X layout is convenient when all groups use the same horizontal measurements:
- Column A: X values, such as hours practiced.
- Column B: Class A scores.
- Column C: Class B scores.
- Column D: Class C scores.
In that layout, each class uses column A for its X-values and its own column for Y-values. If the groups have different X-values, use a separate pair of columns for each one. For instance, columns A and B could hold Class A’s X and Y values, columns D and E Class B’s, and columns G and H Class C’s. The blank spacer columns are optional; they simply make pairs easier to distinguish.
Put headers in the first row, such as Hours, Class A, and Class B, and put observations below them. Keep each series’ X and Y ranges the same length, with the first X value corresponding to the first Y value, the second X to the second Y, and so on. Different series can contain different numbers of points, provided each individual series has matching X and Y point counts.
Use numbers for both axes. If a value looks numeric but is stored as text, Excel may not plot it as expected. Avoid including totals or explanatory notes inside the selected data ranges. A blank cell can represent a missing observation, but do not pair an X value with a Y value from a different row just to fill a gap.
Create the first series
- Select the X-value cells and the matching Y-value cells for the first group. If the columns are adjacent, select the header and data cells for both. If they are separated, select one range, then hold Ctrl on Windows while selecting the other range.
- Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then choose a scatter subtype. Scatter with only markers is a useful starting point for comparing individual observations.
- Click the chart. Open Chart Design > Select Data. In the Select Data Source dialog, choose Add to define another series or edit an existing one.
When creating a chart from a non-adjacent selection, Excel may interpret the selected ranges differently from what you intended. If the first chart looks wrong, do not rebuild the data immediately: open Select Data and check the series definitions. You can also start with a simple chart and explicitly assign its X and Y ranges through the series-editing dialog.
Add and define each series
In the Edit Series dialog, set Series name to the cell containing the group’s header, or enter a clear name. Set Series X values to that group’s numeric X range, and Series Y values to its matching numeric Y range. The range fields should contain data cells, not the column headings. For example, if A1 is Hours and B1 is Class A, with observations in rows 2 through 7, use A2:A7 for the X values and B2:B7 for the Y values.
Click OK to return to Select Data Source. Choose Add again for each additional group, then enter that group’s name and its corresponding X and Y ranges. When finished, choose OK. Excel draws each series in the same plot area, typically assigning a different color to distinguish the groups. The legend identifies the series by its name.
With a shared-X layout, the X range can be the same for each series while the Y range changes. With separate X-Y pairs, enter the X range from the appropriate pair each time. You can also use Select Data to edit an existing series if the chart has plotted the wrong columns: select the series in the list, choose Edit, and correct the name and ranges.
Series ranges can be on the same worksheet or another worksheet in the workbook. Use the range selector in the dialog if selecting cells directly is easier than typing references. If you do type a reference, follow the sheet and range format Excel shows in the dialog; sheet names containing spaces are enclosed in apostrophes by Excel.
Choose markers, lines, and labels
Markers are usually the clearest choice when each observation is an independent measurement. If the points represent a sequence, such as values recorded over time, a scatter subtype with lines can help show the order or trend. Straight lines connect points in their entered order, so sort the data by X when you want the line to progress from low X to high X. Otherwise, connecting lines may zigzag in a way that suggests a pattern that is not present.
To change the appearance of a series, select one of its points and use the Format Data Series pane. Adjust marker shape, size, fill, or outline so groups are distinguishable without relying on color alone. This is useful for printed charts and for readers with color-vision differences. Keep the legend when it helps identify groups; rename series in Select Data if the legend shows generic labels such as Series 1.
Add context with a chart title and axis titles. Select the chart and use Chart Design > Add Chart Element to add titles or a legend. Name each axis with its unit, for example Practice hours and Test score (points). This helps readers distinguish a value such as 10 hours from a score of 10. Use data labels only when individual values need to be read; a label on every point can make a chart with many observations difficult to scan.
Set axis scales and interpret the result
Excel usually chooses axis bounds and tick intervals automatically. If a comparison requires a particular scale, right-click an axis and choose Format Axis. In the Format Axis pane, adjust options such as bounds and units where appropriate. A zero baseline is not always necessary for a scatter chart, but changing the axis minimum can make small differences look larger. Keep the scale choice visible and fair to the question the chart is meant to answer.
Check whether the series share units and a meaningful scale before comparing their vertical positions. If one group contains values in a different unit, a common Y-axis may mislead. A secondary axis is available for some chart types, but it can make visual comparisons harder because the two scales differ. For a straightforward relationship comparison, converting values to a common, clearly explained measure or creating separate charts may be easier to interpret.
Look at the points as a whole rather than assuming that a visible association proves one variable caused another. A rising pattern means higher X values tend to occur with higher Y values in the displayed data; it does not establish why. Consider the number of observations, unusual points, measurement quality, and whether the chart omits relevant groups or conditions.
Common problems and practical checks
- The chart shows one series or the wrong points: Open Chart Design > Select Data, select a series, and use Edit to verify its X and Y ranges. Check that the ranges exclude headers and contain the intended rows.
- The points appear in an unexpected order: Check whether X and Y values have been paired row by row. If using connecting lines, sort each series by its X values while keeping every X-Y pair together.
- The horizontal axis looks like categories: Confirm that the chart type is Scatter (X, Y), not Line. A line chart treats its horizontal axis as categories; a scatter chart uses numeric X positions.
- Some points are missing: Look for blank cells, text-formatted numbers, or errors in either range. Correct the source values and check the chart’s hidden and empty cell settings if relevant.
- The legend has unhelpful names: Edit each series name in Select Data, or point Series name to a descriptive header cell.
- New rows do not appear: Check whether the series ranges include the added rows. For data that grows regularly, consider formatting the source as an Excel table and verify that the chart’s ranges include new observations.
One common misconception is that every series must use the same X-values. It does not: each scatter series can have its own X range and its own Y range. What matters is that the X and Y values within a series match in count and correspond to one another. Also, dates can be used as X-values because Excel stores dates as serial numbers, but confirm that the axis formatting displays them as dates rather than as serial values.
Scatter charts versus line charts
Choose a scatter chart when the horizontal variable is numeric and the spacing between X-values has meaning. Examples include distance versus temperature, dosage versus response, or date versus a measurement where unevenly spaced dates should remain unevenly spaced on the axis.
Choose a line chart when the horizontal values are categories that should be evenly spaced, such as months, names, or stages, regardless of the actual interval between them. A line chart can display numeric-looking labels as categories, but that does not make it equivalent to a scatter chart. For instance, measurements at days 1, 2, and 20 should have a much larger horizontal gap between days 2 and 20 in a scatter chart. A category axis may space all three labels evenly.
Excel for Microsoft 365 on Mac has chart tools with broadly similar scatter-series concepts, although ribbon placement and dialog details can differ. Excel for the web can work with charts, but some chart editing controls are more limited or presented differently than in desktop Excel. If you need the full Select Data and series-range workflow, open the workbook in the Windows desktop app.
Frequently Asked Questions
Can each series have different X-values in an Excel scatter plot?
Yes. In Chart Design > Select Data > Add, specify the X range and matching Y range separately for every series. The X ranges do not need to be identical, but the X and Y ranges within each series should contain corresponding points.
How do I add a third series to an existing scatter chart?
Select the chart, choose Chart Design > Select Data > Add, and enter the third series name, X-values, and Y-values. Choose OK to apply it. Repeat Add for any further series.
Can one scatter chart use a different X column for each group?
Yes. Give each group its own X-Y column pair, then assign the appropriate pair in that series’ Edit Series dialog. Excel does not require all groups to share one horizontal measurement range.
Why does Excel treat my X-values as labels?
The chart may be a Line chart rather than a Scatter chart. Change it using Chart Design > Change Chart Type and select a Scatter subtype. Scatter charts position points by numeric X-value; line charts use a category axis.
Can I make a scatter plot with dates on the X-axis?
Yes. Use real Excel date values for the X range. If the axis displays serial numbers or an unwanted format, right-click it, choose Format Axis, and adjust the number format so the dates are readable.
Related
- Excel Split Names in One Cell Into Two Cells
- Excel Split One Cell Into Multiple Rows: How It Works
- Excel Split Print Area Into Two Pages: Page Breaks
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Consolidate Multiple Sheets: Steps and OptionsTo consolidate multiple sheets in Excel for Microsoft 365 on Windows, go to Data > Consolidate, choose a…
- Excel Scatter Plot Colors by Group: A Step-by-Step GuideTo color an Excel scatter plot by group, put each group in its own data series, then assign…
- Excel Solver Binary Constraint: How to Set It UpYes. In Excel Solver, add a constraint that sets the decision-variable cells to bin (binary); Solver will then…
- Styles in Microsoft Word: How They Work and When to Use ThemStyles in Microsoft Word are named sets of formatting that you can apply consistently to text, paragraphs, tables,…
- How to Create Inbox Folder Rules in OutlookTo create an Outlook inbox rule that sorts messages into a folder, open the Rules settings for your…
- Automatically Remove Duplicates in Excel: Methods and RisksYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Remove Duplicates to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.