Scatter Plot Different Colors in Excel: A Clear Guide

Yes. In Excel, the reliable way to show different colors for different groups in a scatter plot is to make each group a separate data series, then format each series with its own marker color. For a one-time highlight, you can also select and format an individual point.

What “different colors” means in a scatter plot

A scatter chart plots pairs of numeric values: one value along the horizontal axis and another along the vertical axis. Excel formats the markers in a data series together, so points in a single series normally share a color and marker style. A series is a set of X values paired with corresponding Y values.

This distinction matters when your worksheet has one X column, one Y column, and a category column. Excel does not automatically use the category text to color each point in a scatter chart. You need to organize the categories as separate series, or manually recolor particular points. Separate series are usually the best choice because they make the chart’s legend meaningful and keep the colors consistent when data changes.

For example, if a table lists each store’s advertising spend, sales, and region, you might want one color for North and another for South. Use advertising spend as X, sales as Y, and region to determine which series each row belongs to.

Quickest method when the data is already split into groups

If each group already has its own X and Y columns, create a series for each group. For instance, put North X values in A and North Y values in B, then South X values in C and South Y values in D. You can insert the first series as a scatter chart and add the other series afterward.

Select the first group’s X and Y data, including headers if convenient.
Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select a scatter chart style, such as scatter with only markers.
Select the chart and choose Chart Design > Select Data.
In the Select Data Source dialog, choose Add. Enter a series name, then select that group’s X values and Y values in their respective boxes. Do not include the header cells in the X and Y value ranges.
Repeat for each group, then format the series colors and check that the legend identifies them clearly.

For an XY scatter chart, the X and Y ranges must contain the same number of corresponding values. If one range includes a header or an extra cell, Excel may plot points incorrectly or show a series with an unexpected shape. Use the same row boundaries for both ranges.

Separate categories from one table with helper columns

When all observations are in a single list, helper columns can split the categories without rearranging the source data. Suppose A contains Category, B contains X, and C contains Y, with headers in row 1 and observations in rows 2 through 7. For example, the rows might contain North, 10, 22; South, 14, 27; North, 18, 31; South, 21, 35; North, 25, 39; and South, 29, 44.

Put North X in D1 and North Y in E1. With the stated layout, enter this in D2 to keep the X value for North and return a chart-ignored error for other categories:

=IF($A2="North",$B2,NA())

With Category in A, X in B, and Y in C, enter this in E2 to return the matching North Y value or an unavailable value for another category:

=IF($A2="North",$C2,NA())

Copy both formulas down through row 7. In the example, D2 and E2 return 10 and 22, while the South row in row 3 returns #N/A in both helper columns. Excel charts do not plot #N/A values as ordinary points, so the unmatched rows do not appear in the North series. The displayed #N/A cells are intentional; they are not a sign that the chart formula failed.

For South, put South X and South Y in F1 and G1. With the same source layout, enter the following formulas in F2 and G2 respectively, then copy them down:

=IF($A2="South",$B2,NA())

=IF($A2="South",$C2,NA())

Now create a scatter chart and add two series using Chart Design > Select Data > Add. Set the North series name to D1, its X values to D2:D7, and its Y values to E2:E7. Set the South series name to F1, its X values to F2:F7, and its Y values to G2:G7. The ranges are examples; adjust the final row to match your data. If you add observations later, extend the ranges or use an Excel table so the chart can include the new rows.

Set a different color for each series

Excel may assign different theme colors when it creates separate series, but those defaults are not guaranteed to match your preferred palette. To choose them yourself, click a marker in the series once, right-click, and choose Format Data Series. In the formatting pane, open Fill & Line (the paint-bucket icon), then expand Marker. Under Fill, choose a solid fill and select a color; under Border, choose a coordinating outline if needed.

Repeat for the other series. Clicking a marker once selects its entire series, so a color change applies to every point in that group. If you want visible dots without a connecting line, select the series and set its line to No line in the same formatting pane. This is common for scatter plots because connecting unrelated observations can suggest a sequence that is not present in the data.

Use colors that remain distinguishable at the marker size shown in the chart. A dark outline can help light-colored markers stand out against a white background. If the chart will be printed in grayscale or viewed by people with color-vision differences, combine color with another cue, such as different marker shapes, and name the series clearly in the legend.

Color one point without changing its whole group

For a single special observation—perhaps an outlier, a target, or a highlighted customer—you can format one point separately. Click the series once to select it, then click the specific marker again to select only that data point. Right-click and choose Format Data Point, then adjust the marker fill, border, or size in the pane.

The extra click is important: if the whole series is selected, the change affects every point in it. Individual formatting is useful for a small number of deliberate highlights, but it is less convenient for many categories. Manual point colors can also become misleading if the data changes and the highlighted row no longer represents the intended case. For repeated or data-driven categories, separate series are easier to maintain.

Choose a chart structure that stays readable

Before adding colors, decide what the chart should help readers compare. If color represents a category, keep the same color-to-category mapping throughout the workbook and give each series a descriptive name. Avoid using a legend entry such as “Series 1” when a useful name like “North” is available.

Use separate series when groups need their own colors, legend entries, or marker shapes.
Use an individual point format for a small number of exceptions or annotations.
Use a separate chart if many groups overlap so heavily that colors and markers cannot be distinguished.
Use axis titles and units so readers know what the horizontal and vertical values represent.

Too many colors can make a chart harder to interpret, especially when categories are numerous or several series overlap. Consider whether every category needs a distinct series, or whether a filter, a smaller set of meaningful groups, or multiple charts would communicate the pattern more clearly. Color should encode information, not merely decorate the plot.

Common problems and how to fix them

Every point has the same color. The points are probably all in one series. Check Chart Design > Select Data to see whether the categories were added as distinct series. If not, split them using helper columns or add each group’s X and Y ranges separately.

The points appear in the wrong places. Confirm that the X range contains the horizontal values and the Y range contains the vertical values. Check that both ranges start and end on corresponding rows, and that numeric values are stored as numbers rather than text. Scatter charts use actual numeric positions; they do not treat the X values like category labels in a line chart.

The legend names are unhelpful. In Chart Design > Select Data, select a series and choose Edit to change its series name, or use a cell containing the desired label. A clear legend is especially important when color is the main way readers identify groups.

Helper columns show #N/A. That is expected for rows that do not belong to a particular category. The formula uses NA() so those rows are omitted from that series rather than plotted at zero. A zero would be a real numeric value and could create a misleading point near the origin.

New rows do not appear in the chart. The chart may still refer only to the original fixed ranges. Extend the X and Y ranges for each series, or structure the source as an Excel table and ensure the chart series includes the additional rows. Check the helper formulas too; they must be filled down for new observations.

Excel for Mac and Excel for the web

The core idea—use separate series for categories and format each series—is the same in Microsoft 365 for Windows and Excel for Mac. Ribbon names and chart-formatting panes can vary slightly by platform or update, but look for the chart’s Select Data command and the series’ marker formatting controls. On Mac, right-clicking may mean Control-clicking if you are using a trackpad or a mouse configured without a secondary button.

Excel for the web can work with charts, but some detailed formatting controls and dialog layouts may differ from the Windows desktop app. If you cannot find an individual-point or marker setting in the web interface, open the workbook in the desktop version of Excel for the fuller chart-formatting options. Avoid assuming that a missing option means the chart itself cannot contain multiple colored series.

Frequently Asked Questions

Can Excel automatically color scatter points based on text in another column?
Not directly for a single ordinary scatter series. Excel formats a series as a unit, so create separate series for the text categories or manually format individual points. Helper columns with IF and NA() are one way to split a single table.

Can I use different marker shapes as well as colors?
Yes. Select a series, open Format Data Series, and use the Marker options to choose a built-in marker style. Different shapes can make groups easier to distinguish when color alone is not enough.

Will the colors update when I add more rows?
The colors remain assigned to their series, but the chart only plots rows included in its series ranges. Extend those ranges and fill the helper formulas for added rows, or use a chart source that expands with your data.

Why does my scatter chart show a point at zero?
A blank or formula result of zero can be plotted as a real coordinate. For category-splitting helper columns, use NA() for rows outside the series instead of returning zero, so Excel omits those rows from the plot.

Can I make every point a unique color automatically?
Excel’s usual scatter-series formatting does not automatically map a text category to a different color for every point in one series. For a fixed small number of points, format points individually. For repeatable category colors, split the data into separate series.

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.