A Pareto chart of your spending puts categories in descending order as columns and adds a line showing the running percentage of the total. In Excel you build it by summing each category, sorting from largest to smallest, adding a cumulative percentage column and inserting a combo chart. It shows at a glance which few categories make up most of your money going out.
How do you prepare the category table?
List each category once in column A of a summary sheet, from A2 down. In B2 total each category for the period you are studying. If your log has Category in column B and Amount in column C on a sheet called Log, and your start and end dates sit in E1 and E2:
=SUMIFS(Log!$C$2:$C$500, Log!$B$2:$B$500, A2, Log!$A$2:$A$500, ">="&$E$1, Log!$A$2:$A$500, "<="&$E$2)
Now sort. Because formulas are in column B, copy the table and paste as values first, then use Data, Sort, with the total column and Largest to Smallest. If you have Excel 365, you can sort live instead with a SORT formula, but pasting values is fine for a one-off review.
How do you add the cumulative percentage?
With sorted totals in B2:B9, put this in C2 and fill down to C9:
=SUM($B$2:B2)/SUM($B$2:$B$9)
Format column C as a percentage. The anchored first cell makes the range grow as you move down, so each row shows the share of spend up to and including that category.
What does the table look like with sample numbers?
Say one month of made-up spending adds up to ₹70,000 across eight categories:
| Category | Total | Cumulative share |
|---|---|---|
| Rent | ₹25,000 | 35.7% |
| Groceries | ₹14,000 | 55.7% |
| Loan EMI | ₹12,000 | 72.9% |
| Dining out | ₹6,000 | 81.4% |
| Fuel | ₹5,000 | 88.6% |
| Utilities | ₹4,000 | 94.3% |
| Shopping | ₹3,000 | 98.6% |
| Miscellaneous | ₹1,000 | 100.0% |
Rent alone is ₹25,000 of ₹70,000, which is 35.7%. The first four rows add up to ₹57,000, so the top four categories take 81.4% of the month. That is where an 80/20 pattern shows up here, though it is a rule of thumb and not a law of nature, so your own sheet may show something different.
How do you draw the combo chart?
- Select the category names, the totals and the cumulative percentages together.
- Go to Insert, then Recommended Charts, then All Charts, then Combo.
- Set Total as Clustered Column and Cumulative share as Line, and tick Secondary Axis for the line.
- Click the secondary axis, choose Format Axis, and set the maximum to 1 so it stops at 100%.
- Reduce the gap width on the columns and add a clear chart title.
Newer versions of Excel also have a ready-made Pareto chart type in the chart gallery. The combo route gives you more control over the axis and labels, which is why it is worth knowing.
What should you do with the picture?
Look at the chart in two passes. First, note which categories sit left of the point where the line crosses about 80%. Second, ask which of them you can change. Rent and EMIs are fixed in the short run, so the useful targets are usually the flexible ones, such as dining out, fuel or shopping. Cutting a small category to zero changes little, while a 10% trim in a big flexible category can matter more.
To keep the chart honest, switch on data labels only for the points that matter, such as the cumulative value at the fourth category, and let the columns speak for themselves. Too many labels turn a clear picture into noise, and the message you want is simple: which handful of categories decide the month.
Where does a sheet run out of road?
Rebuilding the table every month is repetitive. SpendixAI has a Report builder where you can filter and group spending by category and download the result as CSV, which you can paste straight into this layout. The chart steps stay exactly the same.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

