Excel Bar of Pie Chart: Show Percentages for Each Bar Total
Question details
The user needs to display percentage data labels on an Excel Bar of Pie chart and adjust the labels to represent the desired bar-total percentages.
- Product
- Microsoft Excel Bar of Pie chart
- Device & OS
- not provided
- Scenario
- A chart has been created and the user wants to show percentages on its bars instead of relying on the default overall chart values.
- Observed behavior
- The chart does not currently show the required percentage labels for each bar total.
Select the Bar of Pie chart and confirm that the chart contains the data series you want to label. If the percentages must be calculated from a custom subset rather than the chart total, prepare those percentages in worksheet cells first.
Format Bar of Pie chart labels as percentages
Use this method when the chart already contains the correct data and you only need to add or change its percentage labels.
Excel applies the selected percentage format through the chart's data-label settings. After labels are added, the Format Data Labels pane lets you control which values appear and how they are displayed.
Select the Bar of Pie chart, right-click the chart area or a data series, and choose Add Data Labels.
Right-click one of the new labels and select Format Data Labels to open the formatting pane.
In Label Options, select Percentage. Clear other label options, such as Value, if you want the labels to show percentages only.
Use the Number section in the Format Data Labels pane to choose Percentage and set the desired decimal places. Close the pane when the labels display correctly.
Show percentage labels on Bar of Pie charts in WPS Spreadsheet
WPS Spreadsheet provides familiar chart-formatting controls for adding data labels, selecting Percentage, and adjusting decimal places. You can use the same workflow to format a Bar of Pie chart and keep the chart presentation easy to update.
- 1. Insert or select the chart: Open the workbook in WPS Spreadsheet and select the Bar of Pie chart you want to edit.
- 2. Add chart labels: Right-click the chart or its data series and choose Add Data Labels.
- 3. Format the labels: Right-click a label, choose Format Data Labels, and select Percentage under the label options.
- 4. Set the number format: Open the Number settings in the formatting panel and choose Percentage with the required decimal places.
Frequently Asked Questions
How do I add percentages to an Excel Bar of Pie chart?
Select the chart, right-click the chart or data series, choose Add Data Labels, then right-click a label and select Format Data Labels. Enable Percentage under Label Options.
Can Excel show percentages instead of values on chart labels?
Yes. Open Format Data Labels, select Percentage, and clear Value if you want the labels to display percentages only.
How can I change the number of decimal places in chart percentages?
In the Format Data Labels pane, expand Number, select Percentage, and enter the desired number of decimal places.
Why do the displayed percentages not match each individual bar total?
The built-in Percentage option uses the chart's data series and calculation basis. For a custom bar-total percentage, calculate the percentages in worksheet helper cells and use those results as custom labels.
