FG
💻 Software

Excel pie chart: How to combine smaller values in a single "Other" slice?

Fresh5 days ago
Mar 15, 2026133071 views
Confidence Score0%
0%

Problem

I have this pie chart in Excel 2010 (based on a pivot table): I'd like to combine all the values smaller than X% in a single "Other" slice. In previous versions of Excel, it was possible to use the "split series" option to do this. That option seems to be gone in the latest version. Is there still …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel pie chart: How to combine smaller values in a single "Other" slice?

Low Risk

I'm imagining a Pivot Table with a field called "Part Number." In your pivot table you'll need to sort the items in Part Number so that those with the smallest values are together. Select the items that you want to group into your "Other" category. …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment