Chart & Visualization Issues

Select and Format One Slice in an Excel Pie Chart

Olivia MillerOlivia Miller Nov 12, 2026 869 views

Question details

The user needs to select one data point in an Excel pie chart and open its formatting options.

Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to change the fill color or other formatting for one pie-chart slice, but the chart menu is difficult to access.
Observed behavior
Clicks may select the entire chart or place the user inside chart-text editing instead of selecting an individual slice.
Before you start

Open the workbook and confirm that the pie chart is visible. If the cursor is editing a chart title or label, press Escape before selecting the chart or slice.

Solution 1Recommended

Select one pie-chart slice and open Format Data Point

Use this method when Excel selects the chart or chart text instead of the individual data point.

A pie slice requires two clicks: the first selects the chart, and the second selects the specific data point. After the slice is selected, Ctrl+1 opens the formatting pane for that point.

1
Exit chart-text editing

Click the chart and press Escape repeatedly until Excel is working with the chart rather than editing a title, label, or other chart text.

2
Select the pie chart

Click the pie chart once to select the complete chart area.

3
Select the individual slice

Click the desired pie slice a second time. Only that data point should be selected, usually with selection handles around the slice.

4
Open formatting options

Press Ctrl+1 to open the Format Data Point pane. Use Fill, Line, and other available options to format the selected slice.

Selection check: If the entire pie chart is still selected, click outside the chart, then repeat the one-click chart and two-click slice sequence.

Format an Individual Pie-Chart Slice in WPS Spreadsheets

WPS Spreadsheets lets you select a single pie-chart data point and use the formatting pane to change its fill, line, and other visual properties, with a familiar workflow for Excel files.

  1. 1. Open the spreadsheet: Launch WPS Office, choose Spreadsheet, and open the workbook containing the pie chart.
  2. 2. Exit text editing: If a chart title or label is active, press Escape until the chart itself can be selected.
  3. 3. Select the data point: Click the pie chart once, then click the target slice again to select only that data point.
  4. 4. Format the slice: Press Ctrl+1 or right-click the selected slice and choose the formatting option, then adjust the fill color and other properties in the formatting pane.
Select and customize one pie-chart slice without changing the entire chartUse a familiar chart-editing interface with accessible formatting controlsOpen and edit Microsoft Excel XLSX files with broad format compatibilityMake chart updates in a lightweight spreadsheet editor
QA img-9

Frequently Asked Questions

Why does Excel select the whole pie chart instead of one slice?

The first click normally selects the chart object. Click the chart once, then click the desired slice a second time to select only that data point.

How do I leave chart-title or label editing mode?

Press Escape until the text cursor disappears and the chart object can be selected. Then click the chart and select the slice with a second click.

What shortcut opens the formatting pane for a selected pie slice?

With the individual data point selected, press Ctrl+1 to open Format Data Point and change its fill, line, or other properties.

Can I change the color of only one pie-chart slice?

Yes. Select the chart, click the target slice again to select that data point, open Format Data Point, and choose the desired fill color.