Excel Grouped Scatter Plot: Setup, Steps, and Tips

How-to basics · Updated November 19, 2026

To make a grouped scatter plot in Excel, give each group its own data series, with one range for its X values and another for its Y values. Insert a scatter chart, then use Chart Design > Select Data to add or edit each group as a series. Excel does not automatically split a scatter plot into groups based on a text column, so the data layout matters.

What a grouped scatter plot shows

A grouped scatter plot compares the relationship between two numeric variables while distinguishing observations by category. For example, you might plot study hours on the horizontal axis and test scores on the vertical axis, using a different marker color for each class. Each dot is one observation; the group is identified by the series it belongs to.

In Excel, a scatter chart is made from X and Y values, not from a category axis. That makes it useful when the horizontal values are meaningful numbers, such as time, distance, concentration, or price. A grouped scatter plot is not a special chart type with a separate grouping switch: it is an ordinary scatter chart containing multiple series.

This distinction also explains a common surprise. If you select a table with columns named Group, X, and Y and insert a chart, Excel may not automatically use Group to create separate colored series. It may interpret the selection differently than you expect. You can control the result by preparing separate X/Y ranges for each group or by adding the series manually.

Prepare the data for separate groups

For a small dataset, the clearest layout is a block for each group, with an X column and a Y column. For instance, a worksheet could have Group A X values in A2:A6 and its Y values in B2:B6, then Group B X values in D2:D6 and its Y values in E2:E6. Put the group names in A1 and D1, or in nearby cells that you can use as series names. Each X value must correspond to the Y value on the same row.

It is also common to keep the original records in a tidy, row-by-row table:

  • Group: the category, such as North, Central, or South.
  • X: the numeric horizontal measurement.
  • Y: the numeric vertical measurement.

That layout is convenient for data entry and filtering, but Excel generally needs one X/Y pair of ranges per chart series. For a few groups, copy each group’s X and Y observations into separate blocks. For many groups or regularly refreshed data, use a repeatable preparation process, such as a PivotTable or Power Query workflow, and check the resulting ranges before charting. Keep the tidy source table as the underlying record rather than replacing it with a chart-specific layout.

Use numeric values in both plotted columns. A label such as Low, Medium, or High is not a numeric X value for a standard scatter chart; if the horizontal variable is categorical, a line chart or another chart type may communicate it better. Dates can be plotted because Excel stores dates as serial numbers, but check the axis number format so the scale displays as dates rather than serial values.

Create the chart in Excel for Microsoft 365

  1. Arrange the first group’s X and Y values in adjacent columns, with headers if useful. Select both columns, including headers.
  2. Insert a scatter chart. Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select the scatter subtype you need. For most grouped comparisons, Scatter with only Markers is a good starting point.
  3. Add the other groups. Select the chart, open Chart Design > Select Data, and choose Add. In the Edit Series dialog, enter or select the group name for Series name, select that group’s numeric cells for Series X values, and select its matching Y cells for Series Y values. Do not include the header cells in the X or Y ranges.
  4. Repeat for every group and confirm the dialog. The chart should now show a separate series for each group. Open Select Data again if you need to correct a name, range, or series order.
  5. Label the chart. Use Chart Design > Add Chart Element to add a chart title and axis titles. Name the axes with the variables and units, such as Distance (km) and Time (minutes).

Series ranges should contain the same number of X and Y observations. For example, if Group A’s X range is A2:A6, its Y range should also contain five cells, such as B2:B6. The range references shown in the dialog may include the worksheet name and dollar signs; that is normal. If you select a chart before using the ribbon, make sure you are editing the intended chart rather than a nearby object.

On Excel for Mac, the same approach applies, although ribbon labels and dialog placement can differ slightly by release. Excel for the web can display and edit many chart settings, but some detailed chart-editing controls may be easier to find in the desktop app. The steps above describe Microsoft 365 for Windows.

Format groups so readers can tell them apart

A legend identifies the series names, but the markers also need to remain distinguishable. Select a series and open its Format Data Series pane to change marker shape, size, fill, or border. Using both color and marker shape can help readers distinguish groups in a printed chart or for viewers who have difficulty differentiating colors. Keep the visual treatment consistent: one group should use the same marker design throughout the plot.

Use a clear legend name rather than a generic label such as Series 1. If Excel has not picked up a header, return to Chart Design > Select Data, select the series, and choose Edit to set its name. Axis titles should identify the measurement and units. A title such as Class results is less informative than Study hours and test score by class.

Set the axis bounds thoughtfully. Right-click an axis and choose Format Axis to inspect its scale settings. A zero minimum is not always necessary for a scatter plot, but limits should not hide relevant points or make small differences look misleadingly large. When comparing separate charts, matching axis bounds can make the comparison fairer. Avoid excessive gridlines and oversized markers, which can obscure clusters of points.

Working from one long table

Suppose the source table has Group in column A, X in column B, and Y in column C, with one observation per row. You can filter the Group column to one category, copy the visible X and Y values into a helper block, and repeat for the other categories. Then assign each helper block to its own chart series. This is straightforward for a small, mostly static dataset, but manually copied blocks can become stale when new observations arrive.

For a changing dataset, keep the source table intact and make the chart ranges part of a documented refresh process. After adding rows or groups, verify that the chart includes the new records and that every series still points to the correct X and Y columns. A chart based on fixed cell references does not necessarily expand to include every new record just because the source table has grown. Test the behavior in your workbook rather than assuming that a new row is included.

Filtering the source table is not always a substitute for separate series. A chart with one series can show filtered observations, but it will not automatically give each category its own legend entry and marker formatting. If group identity is part of the comparison, create separate series or use a charting process that explicitly generates them.

Choose markers, lines, and trendlines carefully

Scatter chart subtypes determine whether Excel connects points. Scatter with only Markers is usually appropriate when observations are independent. A subtype with straight lines or smooth lines connects points in their plotted order; that can imply a sequence or path. If you use connecting lines, sort the records by X value when that order is meaningful. Do not connect unrelated categories merely to make the chart look continuous.

A trendline can summarize a relationship within a group, but it is not the same as the plotted data and does not prove that one variable causes another. If you add one, select the intended series first and use Chart Design > Add Chart Element > Trendline. A separate trendline for each group may help compare patterns, but too many lines can clutter the chart. Explain the trendline type and any important limits when the chart is used in a report.

If the horizontal values are just labels for evenly spaced categories, consider whether a line chart is a better fit. A scatter chart positions points according to their actual numeric X values, so the spacing between 2 and 4 is twice the spacing between 2 and 3. A category axis does not preserve that numeric spacing. Choosing between these charts depends on what the X values mean, not simply on which chart looks familiar.

Common problems and how to fix them

  • The chart shows one color or one legend entry: Excel has one series, or several series share the same name and formatting. Open Chart Design > Select Data and confirm that each group is listed separately.
  • Points appear in the wrong places: Check that the X range and Y range belong to the same group, have matching lengths, and exclude headings. A swapped X and Y range can produce a valid chart with the wrong interpretation.
  • Excel plots an unexpected range: Edit the series and inspect the cell references. When selecting ranges manually, avoid including a Group text column as an X or Y range.
  • Some observations are missing: Look for blank cells, text stored in numeric columns, filtered or hidden rows, and ranges that stop before the final record. Confirm whether the chart is configured to show data in hidden rows and columns if that setting is relevant.
  • The markers overlap: Try smaller markers, partial transparency if available in the formatting options, or data labels only for selected points. If many observations share identical coordinates, overlapping points may represent repeated observations rather than a chart error.
  • The chart looks dramatic but the difference is small: Review the axis minimum and maximum. A narrow scale can magnify visual differences, while a very broad scale can hide meaningful patterns.

Before sharing the chart, compare a few plotted points with their source rows. This simple check can catch a reversed range, an omitted group, or an accidental inclusion of a total row. Also verify the legend, units, and axis scale at the size where the chart will actually be read.

Frequently Asked Questions

Can Excel group a scatter plot automatically by a category column?
Not reliably from a standard Group, X, and Y table. Create a separate series for each category, or prepare separate X/Y ranges before inserting or editing the chart.

How do I add another group to an existing scatter chart?
Select the chart and go to Chart Design > Select Data > Add. Enter the group name and select its X and Y ranges in the Edit Series dialog.

Can a grouped scatter plot use different numbers of points in each group?
Yes. Each series can contain a different number of observations, provided that its own X range and Y range contain the same number of values.

Why is my group name missing from the legend?
The series name may be blank or may point to the wrong cell. In Select Data, edit that series and choose a cell containing the group name, or type a clear name in the Series name field.

Should I use a scatter plot or a line chart for grouped data?
Use a scatter plot when both variables are numeric and the actual spacing between X values matters. Use a line chart when the horizontal positions are categories or when the points represent an ordered sequence that should be connected.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.