Chart & Visualization Issues

How to Show Other Percentages in an Excel Pie of Pie Chart

Khadija Khan Oct 23, 2026 869 views

Question details

The user needs to display secondary slice percentages relative to the combined 'Other' category in a Pie of Pie chart, rather than against the total chart value.

How to Show Other Percentages in an Excel Pie of Pie Chart

Product: Microsoft Excel
Device & OS: not provided
Scenario: Presenting a breakdown of smaller data points grouped as an 'Other' category within a main pie chart.
Observed behavior: Default settings calculate the secondary pie slice percentages based on the entire dataset's total, causing confusion for viewers who expect the secondary pie labels to sum to 100%.

Before you start

Prepare an additional helper column in your spreadsheet to manually calculate the percentages of the secondary data points relative only to your 'Other' subtotal.

Solution 1Recommended

Use Helper Columns and Custom Data Labels

Calculate the exact percentages for the 'Other' category in a separate column and apply them to the chart using the 'Value From Cells' data label option.

Since Excel inherently calculates pie chart percentages based on the grand total of the data, the only reliable way to show independent percentages for the secondary pie is to bypass the default calculation by linking the labels to a custom data range.

Calculate the 'Other' Subtotal

Sum the values of the specific data points that make up your 'Other' category using the SUM function in a blank cell.

Determine Custom Percentages

In a new helper column next to your secondary data, divide each individual 'Other' data point by the subtotal you just calculated. Format these new cells as Percentages.

Insert the Chart

Select your original dataset (excluding the helper column), navigate to the Insert tab, click the Pie Chart icon, and select 'Pie of Pie'.

Apply Custom Data Labels

Right-click the slices in the secondary pie and select 'Format Data Labels'. In the formatting pane, check the box for 'Value From Cells', highlight your helper column containing the custom percentages, and uncheck the default 'Percentage' box.

Use Helper Columns and Custom Data Labels

Dynamic Updates: By using cell references for your calculations, your custom data labels will automatically update whenever the source data changes.

Solution 2

Manually Type Annotations for Static Charts

For simple charts that will not be updated with new data, you can manually override the text in the data labels.

Advanced Charting with WPS Office

Design Professional Pie of Pie Charts in WPS Spreadsheet

WPS Spreadsheet provides robust charting tools, including the ability to pull custom data labels from specific cell ranges. This makes it easy to display precise percentages in your Pie of Pie charts while retaining full compatibility with Microsoft Excel files.

1. Open your dataset: Launch WPS Spreadsheet and open the document containing your data.
2. Insert the chart: Highlight your data, navigate to the 'Insert' tab on the ribbon, click the Pie Chart icon, and select 'Pie of Pie'.
3. Add data labels: Right-click the newly inserted chart, select 'Add Data Labels', and then right-click the labels to choose 'Format Data Labels'.
4. Link to custom percentages: In the properties pane on the right, check 'Value From Cells' and select the helper column where you calculated your secondary percentages.

Fully compatible with Microsoft Excel (.xlsx) chart formats and data label settings.Intuitive interface for inserting and customizing complex visualization charts.Built-in 'Value From Cells' feature for absolute control over data label text.Free and lightweight alternative to heavy spreadsheet applications.

microsoft office alternative - wps office

Frequently Asked Questions

Why do secondary pie slice percentages not add up to 100% by default?

By default, spreadsheet software calculates the percentage of every slice (both in the main pie and secondary pie) based on the grand total of the entire dataset. Since the secondary pie represents a fraction of the total data, its individual pieces will only add up to the percentage value of the main 'Other' slice.

Can I change how many items are moved to the secondary pie?

Yes. Right-click any slice in the chart, choose 'Format Data Series', and under 'Series Options', adjust the 'Second Plot Contains the Last' value to specify exactly how many data points are moved to the secondary chart.

Does the 'Value From Cells' option dynamically update?

Yes, as long as your chart's data labels are linked to a helper column that uses formulas (like division to find the percentage), updating your raw data will automatically recalculate the helper column and immediately update the text shown on the chart labels.

Excel & Data Problems