Select and Format One Slice in an Excel Pie Chart
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.
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.
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.
Click the chart and press Escape repeatedly until Excel is working with the chart rather than editing a title, label, or other chart text.
Click the pie chart once to select the complete chart area.
Click the desired pie slice a second time. Only that data point should be selected, usually with selection handles around the slice.
Press Ctrl+1 to open the Format Data Point pane. Use Fill, Line, and other available options to format the selected slice.
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. Open the spreadsheet: Launch WPS Office, choose Spreadsheet, and open the workbook containing the pie chart.
- 2. Exit text editing: If a chart title or label is active, press Escape until the chart itself can be selected.
- 3. Select the data point: Click the pie chart once, then click the target slice again to select only that data point.
- 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.

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.




