Create an Excel Scatter Plot with Marker Shapes and Colors
Question details
Create a scatter plot that uses marker shapes to distinguish Field values and marker colors to distinguish Group values.

- 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.
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.
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.
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.
Select an X and Y range, then choose Insert > Scatter (X, Y) > Scatter with only Markers.
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.
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.
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.

Format Individual Scatter Plot Points Manually
Use this approach for a small chart when creating several series would take longer than formatting the points.
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. 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. Insert a scatter chart: Select one pair of X and Y ranges, then choose Insert > Chart and select a scatter chart with markers.
- 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. 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.

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.




