Math & Statistical
Pie & Doughnut Chart Percentage Share & Small-Slice "Other" Rollup Formula
Compute exact category percentage shares ROUND(B2 / SUM($B$2:$B$6) * 100, 2) and consolidate unreadable < 5% tail categories into a single "Other" slice using SUMIFS(B2:B6, B2:B6, "<" & (0.05 * SUM(B2:B6))).
Preventing unreadable Pie & Doughnut label collisions by rolling < 5% tail slices into "Other"!
Data visualization best practices warn against plotting pie or doughnut charts with tiny 1%–4% slivers whose data labels overlap! Computing explicit percentage shares =ROUND(B2 / SUM($B$2:$B$6) * 100, 2) alongside a dynamic 5%-threshold tail rollup =SUMIFS(B2:B6, B2:B6, "<" & (0.05 * SUM(B2:B6))) consolidates minor channels cleanly before plotting!
Across channel leads [420, 260, 180, 35, 25] (total = 920; 5% cutoff = 46 leads), Organic Search holds 45.65%, while Referral (35) and Affiliates (25) both fall under 46 leads and roll up cleanly into a single 60-lead (6.52%) "Other" slice ready for pie or doughnut charting!
| Acquisition Channel & Leads (Total = 920) | Exact Pie Share % | 5% Tail Cutoff (< 46 Leads) | Chart Grouping |
|---|---|---|---|
| Organic Search (420 Leads) | 45.65% | >= 46 Leads | Standalone Primary Slice |
| Paid Social (260) & Direct (180) | 28.26% & 19.57% | >= 46 Leads | Standalone Slices |
| Referral (35) + Affiliates (25) | 3.80% + 2.72% = 6.52% | < 46 Leads -> Rollup = 60 | Combined "Other" Slice (60) |
Zero-Guarded Pie / Doughnut Slice Percentage Share = ROUND(B2 / SUM($B$2:$B$6) * 100, 2)
Divides category count B2 by total range sum SUM(B2:B6) with negative/zero total protection.
=IF(OR(MIN(B2:B6) < 0, SUM(B2:B6) <= 0), "Pie Slices Require Positive Total", ROUND(B2 / SUM(B2:B6) * 100, 2))Dynamic "< 5% of Total" Tail Rollup ("Other" Slice Sum via SUMIFS)
Sums every category strictly below 5% of the grand total (0.05 * SUM(B2:B6)).
=IF(OR(MIN(B2:B6) < 0, SUM(B2:B6) <= 0), "Pie Slices Require Positive Total", SUMIFS(B2:B6, B2:B6, "<" & (0.05 * SUM(B2:B6))))Try the example
Use the original values or change them to test your understanding.