To chart budget against actual in Excel, list each category with its budget and its actual spend, select the three columns, choose Insert, Combo Chart, and set Actual as Clustered Column and Budget as Line with Markers. Hide the line and keep the markers so each category shows a dot at its budget. Add two helper columns to turn the over-budget columns red.
Set up the data
You need one row per category. Budget is typed in; Actual comes from your transactions with a SUMIFS for the month you are reviewing.
| Category | Budget | Actual |
|---|---|---|
| Groceries | 12,000 | 13,400 |
| Dining out | 4,000 | 3,200 |
| Transport | 5,000 | 5,600 |
| Electricity | 2,500 | 2,300 |
| Subscriptions | 1,500 | 1,500 |
These are made-up numbers for one month. If Actual is in column C and the month starts in a cell F1, the formula for the first row is =SUMIFS(Data[Amount], Data[Category], A2, Data[Date], ">="&$F$1, Data[Date], "<"&EDATE($F$1,1)), copied down.
How do I build the combo chart?
- Select the Category, Budget and Actual columns, headers included.
- Choose Insert, then Combo Chart, then Create Custom Combo Chart.
- Set Actual to Clustered Column and Budget to Line with Markers. Leave both on the primary axis.
- Click OK, then click the Budget line, choose Format Data Series, and set Line to No Line. Under Marker, pick a dash or diamond about 10 points wide.
- Add data labels to Actual only, so the picture is not cluttered.
The result reads quickly: a column that reaches past its marker is over budget, and one that stops short is under.
Do I need a secondary axis?
Not here. Budget and actual are both rupees, so they belong on the same axis. A secondary axis lets the two scales drift apart, and a column can then look under budget when it is not. Use a secondary axis only when the series are in different units, such as rupees and a percentage.
How do I colour only the over-budget bars?
Excel cannot colour one column differently by a rule, so split Actual into two helper columns and plot both.
- Column D, within budget: =IF(C2<=B2, C2, 0)
- Column E, over budget: =IF(C2>B2, C2, 0)
- Plot D and E as columns instead of C. Colour D green or grey and E red.
- Click either column series, choose Format Data Series, and set Series Overlap to 100 per cent so they sit in the same slot.
With the sample above, Groceries (13,400 against 12,000) and Transport (5,600 against 5,000) turn red, while Dining out, Electricity and Subscriptions stay neutral. Subscriptions at exactly 1,500 counts as within budget because of the less-than-or-equal sign.
Common problems
- Budget marker missing: the Budget series may be set to a column. Check Change Series Chart Type.
- Categories in the wrong order: sort the table, not the chart.
- Actual stays zero: dates in the source may be text, so SUMIFS finds nothing. Check that they are right-aligned.
- Chart ignores a new category: extend the range or build the chart from a Table.
Irregular costs need a monthly share in the budget column. If an annual insurance premium is ₹6,000, put ₹500 a month against it (6,000 divided by 12), otherwise the month it is paid shows a huge red bar and every other month looks suspiciously under budget.
What to do with the chart
Look at it once a month, near the same date, and write down one change. If a category is red three months running, the budget may simply be unrealistic; raise it or move money from another line, which is a household decision rather than a spreadsheet one. If you want budgets tracked without maintaining formulas, SpendixAI has budgets, bills and savings goals on its Pro plan.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

