To chart spending by category in Excel, first total your statement rows per category in a small summary table, sort it from largest to smallest, then insert a horizontal bar chart from that table. Bars sorted by size show where the money went at a glance. Pie charts look friendly but make similar categories hard to compare.
Which Excel chart shows spending by category best?
A sorted horizontal bar chart shows category spending best. Each category gets one bar, the longest bar sits at the top, and the category names read left to right without tilting. You compare lengths along a shared baseline, which people judge more accurately than angles or areas.
Column charts, with vertical bars, work too when you have five or six categories. With twelve, the labels under each column either shrink or rotate, and tilted text is slow to read. Horizontal bars give long names such as "Personal and household" all the room they need.
Two settings make the chart easier to read:
- Sort the data, not the chart. Excel draws bars in the order of the source table, so sort the table from smallest to largest if you want the biggest bar at the top. Horizontal bar charts plot the first row at the bottom.
- Add data labels and drop the gridlines. A label at the end of each bar gives the exact amount, which makes the axis and gridlines unnecessary.
Building the category spending summary the chart reads from
The chart should read from a short summary table with one row per category and one total per row, never from the raw statement rows. Raw rows hold hundreds of purchases, and Excel would try to draw a bar for each. The summary has ten or so rows and stays the same size every month.
Here is an example summary for one made-up month. The amounts are illustrations.
| Category | September (example) |
|---|---|
| Rent | 1,250.00 |
| Groceries | 455.20 |
| Car insurance | 300.00 |
| Fuel | 131.75 |
| Utilities | 110.00 |
| Eating out | 96.40 |
| Subscriptions | 41.97 |
The table is listed largest first so it reads easily here. Before you chart it, sort it smallest to largest, so rent ends up as the top bar. Each total comes from SUMIFS over the statement rows, with the category in one criterion and the month in another. If you would rather not write formulas, a pivot table over the same categorized rows produces the same summary. The amounts must be numbers, not text, or the bars come out at zero.
To build the chart from the summary:
- Select the category names and totals, including the header row.
- Choose Insert, then the bar chart group, then Clustered Bar.
- Click a bar, add data labels, and delete the gridlines and the horizontal axis.
- Rename the chart title to the month, such as "Spending, September 2026".
Some categories distort a monthly chart because they are paid once a year. A car registration or an annual subscription can produce one enormous bar in one month. Spotting and averaging those bills is covered in building an irregular expenses budget from 12 months of statements.
Why a pie chart of spending categories misleads
A pie chart of spending shows each category as a slice of the whole month. That answers "what share went to rent?" reasonably well, but it hides almost every other comparison. Slices of 9% and 12% look nearly identical, and with more than five categories the small slices become unreadable slivers.
A pie also has no place for categories you want to compare with a plan. Overspending is a comparison between two numbers, and a pie shows one. Bars handle it naturally: put the planned amount and the actual amount side by side for each category.
Use a pie only when you have three or four groups and the question really is about shares, such as needs, wants and savings. For anything finer, use bars.
How do you chart category spending month by month?
To show category spending across months, put months in columns and categories in rows in the summary table, then use a line chart for two or three categories, or a clustered bar chart for one month against another. A line per category shows a trend. Plotting all twelve categories as lines produces a tangle.
Pick the question first. "Is eating out creeping up?" needs one line across six months. "How did September compare with August?" needs two bars per category. A chart that tries to answer both answers neither.
Single months are noisy. One birthday dinner can double the eating-out bar. A more stable comparison uses a monthly average over several months, and calculating average monthly expenses from statements shows how many months to include. Plotting the average as a second series beside the current month shows which categories ran unusually high.
Updating the spending chart when next month's statement arrives
To update the chart each month, keep the summary table's layout fixed and change only the month it reads. Point every SUMIFS at a single month cell. When you paste the new statement's rows and change that cell from September to October, the totals and the chart redraw with no editing.
A short routine works well:
- Paste the new rows below the previous month's rows in the transactions sheet.
- Change the month cell above the summary table.
- Re-sort the summary table smallest to largest, since the order changes month to month.
- Save a copy of the chart as a picture if you want a record of each month.
If you also spend cash, those purchases never appear on the bank statement, so the chart understates some categories. A free cash book template logs money in and out by hand with a running balance, and its rows can feed the same summary.
When your bank only provides PDF statements, the rows have to come from somewhere. CheapBankConvert turns a PDF statement into an Excel file with amounts stored as numbers, so the SUMIFS totals work as soon as you paste. It is in early access, and you can get started to hear when it opens.