To make a pie or donut chart of expenses in Google Sheets, prepare one small table of category totals, select it, choose Insert then Chart, switch the type to Pie chart and set a Donut hole. The preparation matters more than the clicks: a donut with fifteen slices is unreadable, so show the top six categories and group the rest as Other.
How do I get one total per category?
Assume your entries are on a sheet called Data, with category in column B and amount in column C. List each category once in A2:A16 on a Summary sheet, then in B2 enter =SUMIFS(Data!$C$2:$C$1000,Data!$B$2:$B$1000,A2) and fill down. Add a header row, Category and Amount, in row 1.
How do I keep only the top six and group the rest?
In D2 enter this to sort the totals from highest to lowest and keep six rows:
- =ARRAY_CONSTRAIN(SORT(A2:B16,2,FALSE),6,2)
That fills D2:E7. In D8 type Other, and in E8 enter =SUM(B2:B16)-SUM(E2:E7). The chart source is then D1:E8 with its own header row. Because Other is a subtraction, the donut always adds up to your full spend.
Here is a hypothetical month so you can check your own arithmetic:
| Category | Amount (₹) | Share of ₹39,200 |
|---|---|---|
| Rent | 18,000 | 45.9% |
| Food | 9,500 | 24.2% |
| Transport | 3,200 | 8.2% |
| Utilities | 2,800 | 7.1% |
| Shopping | 2,600 | 6.6% |
| Health | 1,500 | 3.8% |
| Other (subscriptions 900 + misc 700) | 1,600 | 4.1% |
The top six add up to 37,600, plus 1,600 for Other gives 39,200. The shares add to 99.9 because of rounding.
What are the exact steps to insert the chart?
- Select D1:E8.
- Choose Insert, then Chart. Sheets may suggest a type; change it to Pie chart in the Chart editor under Setup.
- Open Customize, then Pie chart, and drag the Donut hole slider to about 50 percent.
- In the same section, set Slice label to Percentage (or Value and percentage if you want rupees too).
- Under Chart and axis titles, give it a plain title such as Spending by category, November.
If Other turns out larger than your biggest named slice, you have hidden too much. Raise the 6 in ARRAY_CONSTRAIN to 7 or 8, and adjust the Other formula to match. The aim is that no single slice labelled Other is a mystery.
Why does my pie chart look wrong?
- A category with a negative total, such as one with more refunds than purchases, cannot be drawn as a slice. Remove it from the source or adjust it first.
- If Rent dwarfs everything, the other slices look tiny. That is the truth of the month, but a horizontal bar chart of the same table can compare small items more clearly.
- Labels crowding the ring are a sign you have kept too many categories. Use fewer slices.
Keep the chart on the Summary sheet next to its table, not buried on a tab of its own. When a category total changes on the Data sheet, you will see the donut redraw straight away, which is a quick way to confirm that your formulas are wired up correctly.
How do I keep the colours consistent?
Sheets assigns colours by slice position, so when the ranking changes, Food might swap colour with Transport from one month to the next. That confuses anyone comparing two charts. To avoid it, open Customize, then Pie chart, then Slice, and set a fixed colour for each named category, or accept that the colours follow rank and rely on the percentage labels instead. For a one-page household review, labels with names and percentages beat a separate legend every time.
Does it update when I add expenses?
Yes. The SUMIFS cells recalculate, the sorted block reorders itself and the chart redraws. The only manual step is adding a brand-new category to the list in A. If you would rather not maintain that, SpendixAI shows a spending breakdown and ready-made reports from the same categorised statements, and you can still download the data as CSV for a custom chart.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

