A dual-axis chart puts income on one vertical scale and spending on another, so the two lines can be drawn at whatever heights the scales dictate. Because the scales are independent, the lines can touch or cross even when income is far above spending. The fix is to plot both on one axis, or to plot the gap between them as its own line.
How can the lines cross when nothing changed?
Say your income is ₹80,000 every month for six months, April to September. Spending is ₹56,000 for five months, then ₹58,000 in September, a small rise of ₹2,000. Draw income against a left axis from ₹0 to ₹1,00,000 and spending against a right axis from ₹50,000 to ₹60,000. Income sits at 80% of the chart height (₹80,000 ÷ ₹1,00,000). Spending sits at 60% for the first five months, because (₹56,000 − ₹50,000) ÷ ₹10,000 = 0.6. In September it jumps to 80%, because (₹58,000 − ₹50,000) ÷ ₹10,000 = 0.8.
So in September the spending line reaches the income line, and the chart appears to say "you spent everything you earned". In fact you still had ₹22,000 left over.
| Month | Income | Spending | Left over | Spending line height on the right axis |
|---|---|---|---|---|
| April to August (each) | ₹80,000 | ₹56,000 | ₹24,000 | 60% |
| September | ₹80,000 | ₹58,000 | ₹22,000 | 80%, same as the income line |
Why do two axes mislead?
- Each line is scaled to fill its own space, so the heights tell you about the axis choice, not about the money.
- The point where lines cross carries no meaning, but the eye reads it as "spending overtook income".
- Readers have to check two scales, and most do not. They compare heights directly.
- Whoever draws the chart can make the lines touch or separate by changing one axis range.
What should you plot instead?
- Both on one axis. Draw income and spending against the same scale, from zero. The gap between the lines is then a true gap: ₹80,000 against ₹56,000, ₹24,000 apart.
- The gap as a single line. Plot income minus spending each month: ₹24,000, ₹24,000, ₹24,000, ₹24,000, ₹24,000, ₹22,000. The dip is visible, and its size is honest.
- The savings rate as a line. ₹24,000 ÷ ₹80,000 is 30%, and ₹22,000 ÷ ₹80,000 is 27.5%. A fall of 2.5 percentage points, plainly shown.
Note what the honest versions say: spending rose by about 3.6% (₹2,000 ÷ ₹56,000), and what was left over fell by about 8.3% (₹2,000 ÷ ₹24,000). That is worth noticing, but not alarming.
How do you build the gap chart in a spreadsheet?
With income in column B and spending in column C, put =B2-C2 in column D and fill down. Select the month and gap columns and insert a line or column chart. For the savings rate, use =(B2-C2)/B2 and format the cells as percentages. Both formulas work in Excel and Google Sheets.
Is there a case for a chart at all?
For six months of two figures, a small table can say more than any chart. If you do chart it, one axis and a gap line are enough. A chart should make comparison easier; if you need to explain its scales first, it has stopped doing that.
Where does a tracker help?
SpendixAI lets you download report results as CSV, so you can chart your numbers with one axis yourself. Whatever tool you use, read the axes first and compute the real gap before reacting to where the lines meet.
Quick check
- Do both lines use the same axis?
- Do both axes start at zero?
- What is the actual gap in rupees?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


