Chart & Visualization Issues

Create an Excel Scatter Plot with Marker Shapes and Colors

Phi Hung VoPhi Hung Vo Nov 18, 2026 870 views

Question details

Create a scatter plot that uses marker shapes to distinguish Field values and marker colors to distinguish Group values.

Create an Excel Scatter Plot with Marker Shapes and Colors
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user has numeric X and Y values along with categorical Field and Group columns and wants to show both categories in one scatter chart.
Observed behavior
The desired chart assigns a consistent shape to each Field value and a consistent color to each Group value.
Before you start

Check that your X and Y columns contain numeric values and that each row has the intended Field and Group labels. Decide which marker shape represents each Field and which color represents each Group.

Solution 1Recommended

Create a Series for Each Field and Group Combination

Use separate series when you want consistent formatting for categories and a legend for each combination.

Excel scatter charts do not automatically assign marker shapes and colors from two categorical columns. Each series can instead represent one Field-and-Group combination.

1
Prepare the series data

In the worksheet, create paired X and Y ranges for each Field-and-Group combination. Keep each point's X and Y values together and label each pair with its combination.

2
Insert a scatter chart

Select an X and Y range, then choose Insert > Scatter (X, Y) > Scatter with only Markers.

3
Add the remaining series

Select the chart and choose Chart Design > Select Data. Click Add, enter the combination as the series name, and select its X and Y ranges. Repeat for the other combinations.

4
Set shapes and colors

Right-click a series and select Format Data Series. Under Fill & Line > Marker, choose a built-in shape in Marker Options and set its Fill and Border colors. Use the same shape for every series with the same Field and the same color for every series with the same Group.

5
Check the legend

Select the chart and use Chart Design > Add Chart Element > Legend to display the series names. Verify that each legend entry identifies its Field-and-Group combination.

Create a Series for Each Field and Group Combination
Legend entries: The legend identifies series combinations, rather than automatically creating separate keys for Field shapes and Group colors.
Create scatter charts in WPS

Build a Category-Coded Scatter Plot in WPS Spreadsheets

Use separate chart series in WPS Spreadsheets to assign marker shapes to Field values and colors to Group values.

  1. 1. Prepare the data: Open your workbook in WPS Spreadsheets and arrange numeric X and Y values into paired ranges for each Field-and-Group combination.
  2. 2. Insert a scatter chart: Select one pair of X and Y ranges, then choose Insert > Chart and select a scatter chart with markers.
  3. 3. Add the other series: Select the chart, open Select Data from the chart tools, and add a named series with its X and Y ranges for each remaining combination.
  4. 4. Format the markers: Right-click each series and open Format Data Series. Set its marker shape and color so matching Field values share a shape and matching Group values share a color.
Distinguish Field and Group combinations with marker shapes and colorsOpen and edit Microsoft Excel XLS and XLSX filesCreate and format charts in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel assign marker shapes and colors directly from two category columns?

Excel does not automatically map both categorical columns to scatter marker shapes and colors. Create a series for each Field-and-Group combination and format each series, or format individual points manually.

How do I change the shape of a scatter plot marker?

Right-click a series and choose Format Data Series. Under Fill & Line > Marker > Marker Options, choose a built-in marker shape. To change one point instead, click the series and then click the point again before choosing Format Data Point.

Why does the legend show combinations rather than separate Field and Group keys?

Excel creates scatter chart legend entries from series names. If each series represents a Field-and-Group combination, the legend shows those combinations rather than separate shape and color keys.

Which data should I select for the X and Y values?

In Chart Design > Select Data, select the numeric X range and its matching numeric Y range for each series. Each pair of values should come from the same original data row.