To show chart values in lakhs, plot a helper column that divides your rupee amounts by 100000, or keep the original data and set the axis Display Units to Hundred Thousands, which equals one lakh. Both work; the helper column is easier to audit, while Display Units leaves your data untouched.
Does Excel have a lakh option for chart axes?
Not by that name. In Format Axis, under Axis Options, the Display units list runs through Hundreds, Thousands, Ten Thousands, Hundred Thousands, Millions and so on (the exact list depends on your Excel version, so look at yours). Hundred Thousands is the same as a lakh, and Ten Millions is the same as a crore. The axis then shows 1.5 where the value is 1,50,000, and a label box reading Hundred Thousands appears unless you untick Show display units label on chart.
Option A: use a helper column
Say your monthly summary has the month in column A and total spend in column B. Add column C titled Spend (₹ lakh).
- In C2 type =B2/100000 and fill down to the last month.
- Format column C with 0.00 so values read as 1.20, 1.45 and so on.
- Select A and C, then Insert a column or line chart.
- Name the axis title Spend in ₹ lakh and delete the legend if there is only one series.
For a hypothetical month with total spend of ₹1,20,000, C2 shows 1.20. A ₹45,000 month shows 0.45, and the chart bars scale accordingly.
Option B: keep the data and format the axis
- Click the vertical axis, open Format Axis and set Display units to Hundred Thousands.
- Untick Show display units label on chart, then add your own axis title.
- In Number, under Axis Options, choose Custom and enter 0.0"L" so tick labels read 0.5L, 1.0L, 1.5L.
- Data labels on the bars do not follow axis display units. Format them separately or they will still show full rupees.
Which option is easier to keep correct?
| Point | Helper column | Display Units |
|---|---|---|
| Data labels in lakhs | Automatic | Needs a separate format |
| Chart copied to another file | Works if column is included | Setting travels with chart |
| Risk of mixed units | Low, the header states the unit | Higher, easy to forget the setting |
| Extra column in the sheet | Yes | No |
| Rounded values | You control decimals | Axis decides |
What should you avoid?
Do not use a custom number format alone (without dividing) and expect lakhs. A format can add L but cannot divide, so a bar for ₹1,20,000 would be labelled 120000L, which is wrong. If the axis format shows the L suffix, make sure the plotted numbers are already in lakhs or that Display Units is active.
Can I show lakhs on a monthly spending chart in practice?
Yes, and the helper column method scales neatly. Suppose your hypothetical monthly totals are ₹95,000, ₹1,12,000 and ₹1,40,000. Dividing by 100000 gives 0.95, 1.12 and 1.40, and the chart axis can run from 0 to 1.6 in steps of 0.2. Readers see that the third month is a little over one and a third lakh without counting zeros. If your monthly spend is always well under a lakh, thousands may be the more natural unit, so choose what makes the axis readable rather than what sounds grand.
A quick test before you share
- Pick one bar and compare it with its row in the table.
- Check that the lowest and highest months look sensible on the axis.
- Make sure the helper column rounds only for display, never inside later calculations.
- Keep the rupee column in the file, even if you hide it, so you can trace any number later.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

