Use a pie chart only when you have up to about five parts that add up to a meaningful whole and you want to show share. For ten categories, or when you want to compare one category with another, use a sorted bar chart. People judge lengths on a common baseline more easily than angles, so bars win for comparison.
What does the same ten-category data look like?
Here is a hypothetical month totalling ₹50,000. Try it in both chart types to see the difference.
| Category | Amount (₹) | Share |
|---|---|---|
| Rent | 18,000 | 36% |
| Groceries | 9,000 | 18% |
| Shopping | 5,000 | 10% |
| Eating out | 4,500 | 9% |
| Transport | 3,500 | 7% |
| Utilities | 3,000 | 6% |
| Health | 2,500 | 5% |
| Entertainment | 2,000 | 4% |
| Phone and internet | 1,500 | 3% |
| Subscriptions | 1,000 | 2% |
Why does the pie struggle with ten slices?
- Slices of 3% and 2% are slivers, and their labels collide.
- Eating out (9%) and Shopping (10%) look almost the same, though one is ₹500 larger.
- Colours repeat or become hard to tell apart beyond five or six.
- The reader has to match a legend to the wedges, which slows them down.
A sorted bar chart gives the same ten numbers a clear order: Rent at the top, Subscriptions at the bottom, with exact values at the end of each bar.
Is a donut or a stacked bar any better?
A donut has the same weakness as a pie, with a hole in the middle. A single stacked bar that adds to 100% is easier to read when you have four or five segments, because the segments sit side by side on a straight edge. For ten categories, none of the part-of-a-whole charts is good; fall back to bars, and put the shares in the labels or a column beside the chart.
When is a pie chart the right choice?
A pie works when the question is "what share of the whole is each part?" and there are few parts. Rent, Food and Everything else, for example, give a pie of three slices. Group small categories into an Other slice (here, Health, Entertainment, Phone and Subscriptions together make ₹7,000, or 14%) and keep the biggest five. Put the slices in descending order starting at 12 o'clock.
How do I build the bar chart in Excel?
- Sort the table by Amount from largest to smallest.
- Select Category and Amount, then Insert, Bar Chart, Clustered Bar.
- Excel plots the first row at the bottom of a horizontal bar chart. Click the vertical axis, open Format Axis, and tick Categories in reverse order.
- Add data labels and delete the gridlines and legend; the labels already carry the numbers.
- Use one colour for all bars, and a second colour only to highlight one category you want to talk about.
Which chart answers which question?
| Question | Better chart |
|---|---|
| Where did most of my money go? | Sorted bar |
| What share does rent take of the whole? | Pie or a single stacked bar |
| Did Groceries go up compared with last month? | Clustered bars, one pair per category |
| How did spending change over the year? | Line chart (see the monthly trend article) |
How do I show the amount and the share on each bar?
In a helper column build a label such as ₹18,000 (36%) with =TEXT(B2,"#,##0")&" ("&TEXT(B2/SUM($B$2:$B$11),"0%")&")". Then add data labels to the bars, choose Format Data Labels, and tick Value From Cells (Excel 2013 or later), pointing at the helper column. The bar length carries the comparison and the label carries the exact figures, so the reader does not need a legend or a separate table.
Before you paste it into a report
- Check that the shares add up to 100%, or the bars to the total.
- State the period and unit in the title, for example Spend by category, April, ₹.
- Keep category names short so they fit on one line.
- If a reader will print in black and white, rely on labels and order rather than colour alone.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


