To chart income against expenses with a savings rate, list each month with its income and expense, add Net as income minus expense, and Savings rate as net divided by income. Select the month, income, expense and rate columns, make a combo chart with the rate as a line on the secondary axis, and format that axis as a percentage.
The table behind the chart
Use one row per month. Income and Expense come from SUMIFS on your transactions, or from a pivot. The other two columns are simple.
- Net: =B2-C2
- Savings rate: =IF(B2=0, NA(), D2/B2)
The NA() matters. If a month has no income entered yet, an empty text result would plot as zero and drag your line to the floor. #N/A makes Excel skip the point. Format column E as Percentage with one decimal.
| Month | Income (₹) | Expense (₹) | Net (₹) | Savings rate |
|---|---|---|---|---|
| Apr | 80,000 | 62,000 | 18,000 | 22.5% |
| May | 80,000 | 71,000 | 9,000 | 11.3% |
| Jun | 85,000 | 66,000 | 19,000 | 22.4% |
| Jul | 80,000 | 84,000 | -4,000 | -5.0% |
These are made-up figures. May's rate is 9,000 divided by 80,000, which is 11.25 per cent, shown as 11.3 per cent. July's expense exceeds income, so the rate is negative.
Build the combo chart
- Select Month, Income, Expense and Savings rate. Hold Ctrl to pick the non-adjacent columns.
- Choose Insert, then Combo Chart, then Create Custom Combo Chart.
- Set Income and Expense to Clustered Column. Set Savings rate to Line with Markers and tick Secondary Axis.
- Right-click the right-hand axis, choose Format Axis, and set the number format to Percentage with 0 decimals.
- Label the savings rate points only, so the columns stay uncluttered.
Do I need two axes?
Yes, here. Rupees run into tens of thousands and a rate runs from perhaps minus 10 to 40 per cent. On one axis the rate would sit flat at the bottom. The cost of a secondary axis is that the two scales are unrelated, so the line crossing a column means nothing. Say so in the chart title or a small note.
What counts as expense?
This is the choice that changes your savings rate most. Decide once whether EMI principal, insurance premiums and money you move into a recurring deposit or a SIP count as expense or as savings, then write the rule on the sheet. Changing the rule halfway through the year makes months incomparable. A salaried household might also keep income as take-home pay rather than gross, to match what actually reaches the bank.
For a yearly figure, divide total net by total income rather than averaging the monthly rates. For the four months above, net is 18,000 + 9,000 + 19,000 - 4,000 = 42,000 and income is 325,000, so the rate is about 12.9 per cent. The average of the four monthly rates is about 12.8 per cent, close but not identical, because bigger months weigh more.
Order the months by financial year
In India it is natural to start at April and end at March. Sort the month column by a helper holding the month's position, or generate the months with =EDATE(first month, 1) down the column, starting from 1 April. The chart then reads in the order your accounts do.
Reading it without judging yourself
The line is a picture of how much was left after a month's spending, not a score. Look for the reason behind a dip: a family trip, a festival, a one-off repair. Then decide whether it was a plan or a surprise.
When maintaining a monthly sheet becomes a chore, SpendixAI can pull in statements you upload as PDF, CSV or Excel, and its dashboard and insights show spending without any formulas. Until then, this chart is a good habit: update it on the same date each month and glance at the line.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


