Chart & Visualization Issues

Fix Missing Format Data Point Option in Excel Charts

Camila Milosovich Oct 10, 2026 869 views

Question details

The user cannot find the 'Format Data Point' option when attempting to edit specific parts of a chart, such as a doughnut or gauge chart.

How to Fix the Missing Format Data Point Option in Excel Charts

Product: Microsoft Excel
Device & OS: not provided
Scenario: Customizing the appearance of a chart by editing individual data slices or points.
Observed behavior: The 'Format Data Point' option is missing from the right-click context menu because the entire chart or data series is selected instead of the specific data point.

Before you start

Ensure you are clicking precisely inside the chart area and verify that your Excel worksheet is not protected, as worksheet protection can disable formatting options.

Solution 1Recommended

Select the Individual Data Point Correctly

The most common reason for the missing option is that the entire chart series is selected instead of a single data point. Isolating the point will reveal the correct menu.

In Excel, a single click on a chart selects the entire data series. To format just one segment, such as a single bar or doughnut slice, you must perform a secondary click to isolate it.

Select the data series

Click once on any part of the chart data (e.g., a bar or pie slice). You will see selection dots appear around all the data points in that series.

Isolate the data point

Click a second time specifically on the single data point or slice you want to modify. The selection dots should now only surround that specific piece.

Open the formatting menu

Right-click the isolated data point and choose 'Format Data Point' from the context menu to access the customization options.

Select the Individual Data Point Correctly

Selection Tip: Do not double-click too quickly. Click once, pause for half a second, and click again to properly select a single data point.

Solution 2

Reset Chart Style and Update Excel

If you are selecting the data point correctly but the option is still unavailable, the chart might be experiencing a graphical glitch.

Effortless Chart Editing

Easily Format Chart Data Points with WPS Spreadsheet

WPS Office provides an incredibly intuitive interface for creating and formatting charts. Selecting and customizing individual data points in doughnut, pie, or bar charts is completely seamless and fully compatible with Microsoft Excel.

1. Open your workbook in WPS: Launch WPS Spreadsheet and open your existing Excel file containing the chart.
2. Select the chart slice: Click once on the chart series, then click again on the specific data point or doughnut slice you want to customize.
3. Format the data point: Right-click the highlighted point and select 'Format Data Point' to instantly open the formatting properties pane.
4. Apply customizations: Use the right-side task pane to easily adjust fill colors, borders, transparency, and shadow effects.

100% compatible with Microsoft Excel (.xlsx) charts and data formatsIntuitive single and double-click mechanics for quick data point selectionRich built-in chart templates and professional customization optionsFree and lightweight software that handles large datasets effortlessly

microsoft office alternative - wps office

Frequently Asked Questions

Why does clicking my chart open 'Format Data Series' instead of 'Format Data Point'?

A single click on a chart selects the entire data series as a whole. You must click the specific data point a second time to isolate it. Only then will the right-click menu display 'Format Data Point'.

Can I format a data point if my Excel worksheet is protected?

No. If the worksheet is protected with object editing restricted, the option to format data points will be grayed out or entirely missing. You must go to the Review tab and click 'Unprotect Sheet' before formatting the chart.

Does formatting a single data point affect the rest of my chart?

No, modifying a single data point (like changing the color of one slice in a pie chart) only applies to that specific selection. The rest of the data series will retain its original formatting.

Are there keyboard shortcuts to access the Format Data Point pane?

Yes. Once you have successfully selected the individual data point using your mouse or arrow keys, you can press Ctrl + 1 on your keyboard to instantly open the formatting task pane.

Excel & Data Problems