Chart & Visualization Issues

How to Change Excel Chart Data Point Marker Size and Color

Olivia Miller Sep 28, 2026 870 views

Question details

The user needs to increase the size and modify the color of specific data point markers (such as triangle markers) within an existing Excel chart.

How to Change Excel Chart Data Point Marker Size and Color

Product: Excel
Device & OS: not provided
Scenario: Customizing the visual appearance of a line or scatter chart to make specific data points stand out more clearly.
Observed behavior: The user is attempting to adjust chart markers but requires the exact steps to locate the Built-in settings in the Format Data Series pane, and may encounter scenarios where the Marker Options menu is unexpectedly missing.

Before you start

Ensure you have an existing line chart with markers or a scatter chart selected in your spreadsheet, as standard bar or pie charts do not utilize data point markers.

Solution 1Recommended

Adjust Marker Size and Color using the Format Data Series Pane

Use Excel's built-in formatting tools to easily customize the shape, size, and color of your chart markers.

The Format Data Series pane contains all the necessary styling controls for chart elements. By accessing the Marker Options, you can switch from default markers to built-in shapes like triangles, squares, or circles, and adjust their scale and colors for better visibility.

Select the Data Series

Click directly on the data line or any of the existing markers in your Excel chart. This will highlight the entire data series.

Open Format Data Series

Right-click the highlighted data series and choose 'Format Data Series' from the context menu. A formatting pane will appear on the right side of your screen.

Navigate to Marker Settings

In the Format Data Series pane, click the 'Fill & Line' icon (which looks like a paint bucket). Under this section, click on the 'Marker' tab located next to 'Line'.

Change Marker Size and Type

Expand the 'Marker Options' section. Select the 'Built-in' radio button. From the 'Type' dropdown, choose your desired shape (e.g., a triangle), and adjust the 'Size' number to enlarge the marker.

Modify Marker Colors

Scroll down to 'Marker Fill' and 'Marker Border'. Choose 'Solid fill' for both, and use the color bucket tool to select new interior and outline colors for your markers.

Adjust Marker Size and Color using the Format Data Series Pane

Pro Tip: If you only want to change a single marker instead of the whole line, click the series once, pause, and click the specific data point again before right-clicking to select 'Format Data Point'.

Solution 2

Troubleshoot Missing Marker Options

Resolve the issue where the Marker Options menu is hidden or missing from the formatting pane.

Format Charts Easily in WPS Office

Customize Chart Markers with WPS Spreadsheet

WPS Spreadsheet offers a powerful and intuitive chart formatting engine. You can effortlessly adjust data point marker sizes, apply custom shapes, and change colors to make your data presentations visually appealing.

1. Insert a Chart with Markers: Highlight your dataset, navigate to the Insert tab, and select a Line with Markers or a Scatter chart.
2. Access the Formatting Pane: Double-click on the data series line within the chart to instantly bring up the right-hand Format Data Series pane.
3. Customize Marker Settings: Click the Marker tab in the pane. From here, you can directly switch the marker type to shapes like triangles, adjust the size slider, and pick vibrant colors for the fill and borders.

Completely free and lightweight spreadsheet softwareFully compatible with Microsoft Excel (.xlsx) files and chartsIntuitive right-hand formatting pane for precise visual adjustmentsRich library of built-in chart styles and marker designs

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I find 'Marker Options' in my Excel chart?

Marker options only appear for chart types that support them, such as 'Line with Markers' or 'Scatter' charts. If your chart type is correct but the option is missing, the chart might be corrupted or generated by a VBA script. Try creating a new chart from your data.

How do I change the color of just one specific data point marker?

Click once on the data series line to select all markers, then click a second time on the specific marker you want to alter. Right-click that single marker, choose 'Format Data Point' (instead of Data Series), and apply your custom fill and border colors.

Can I use a custom image as a data point marker?

Yes. In the Format Data Series pane, under the 'Marker Fill' section, choose the 'Picture or texture fill' option. You can then insert an image from your computer to act as a custom visual marker for your data points.

Excel & Data Problems