To fix a chart with too many categories, set a threshold, say 4.5 per cent of total spending, and relabel every category below it as Other before charting. You can do that with a helper column using SUMIFS, or by grouping the small items inside a pivot. Better still, switch a crowded pie into a sorted bar chart.
When is a pie chart too crowded?
A pie works for about five or six slices. Beyond that, labels collide, similar shades blur, and nobody can tell a 2 per cent slice from a 3 per cent one. If you have fourteen categories, either group the tail or use a horizontal bar chart sorted largest first, which can carry many more labels clearly.
A helper column with a threshold
Put the threshold in a cell, say H1 holding 4.5%. In your transactions Table add a column called Chart category with this formula:
=IF(SUMIFS([Amount], [Category], [@Category]) / SUM([Amount]) < $H$1, "Other", [@Category])
It adds up the spending for that row's category, divides by the grand total, and writes Other when the share is under the threshold. Build your pivot or chart on Chart category instead of Category. Change H1 and the whole chart regroups. The SUMIFS ignores any filter you apply, so for one month's shares add Date criteria inside it, as in the budget chart method.
Grouping inside a pivot instead
- Insert a PivotTable with Category in Rows and Amount in Values.
- Click the first small category, then hold Ctrl and click the others.
- Right-click, choose Group, and a new item called Group1 appears.
- Click Group1 and type Other over the name.
This is manual, so the grouping does not move when your data changes, but it needs no formulas and is fine for a one-off chart.
A worked example: fourteen categories down to seven
Say one month's spending is ₹49,800 across fourteen categories. At 4.5 per cent the cut-off is ₹2,241. Anything below that is folded into Other.
| Kept as its own slice | Amount (₹) | Folded into Other | Amount (₹) |
|---|---|---|---|
| Rent | 18,000 | Mobile and internet | 1,500 |
| Groceries | 9,000 | Subscriptions | 1,200 |
| Dining out | 4,500 | Medical | 2,000 |
| Transport | 3,600 | Gifts | 1,800 |
| Electricity | 2,400 | Gym | 1,000 |
| Clothes | 3,000 | Pets | 800 |
| Other (total) | 9,300 | Parking and stationery | 1,000 |
The right-hand column adds up to 1,500 + 1,200 + 2,000 + 1,800 + 1,000 + 800 + 1,000 = 9,300, and the left side without Other is 40,500, so the total stays 49,800. Fourteen categories became six plus Other, which is seven.
If you would rather keep every item and simply show fewer of them, skip the grouping. Sort the pivot from largest to smallest, then use Row Labels, Value Filters, Top 10 and ask for the top 7 items by Sum of Amount. The chart then shows seven bars, and a separate total line can carry the rest.
Choosing the threshold
- Start at 3 to 5 per cent of total spending and adjust until you have six or seven slices.
- Never group a category you are actively trying to cut, however small.
- Keep fixed items such as rent separate if they swamp the rest, and chart them on their own.
- Write the threshold on the sheet so the reader knows what Other means.
Say what Other contains. Put a line under the chart such as Other = eight categories each under 4.5 per cent of spending, and keep a small table beside it listing them with amounts. A reader who sees a large Other slice with no explanation will assume something is being hidden.
Keep the detail somewhere
Grouping changes the chart, not the data. The original Category column stays untouched, so a pivot built on it still shows every line. If SpendixAI is where your categories live, its custom categories and sub-categories let you keep the fine detail in the records and build a simpler grouping only when you chart.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


