How can I change the values on the Y axis?

[Tameem]

Hello all,

I am generating a chart dynamically that has large numbers, i.e, 30,00,00,000 and the sort. I want to display the numbers on the Y axis in lakhs format, rather than displaying it as a whole. Is there any way I can do this? Any help would be appreciated.

Thanks

[pmailkeey]

Try formatting them in lakhs in the spreadsheet using custom formatting. (See: https://stackoverflow.com/questions/32359814/displaying-lakhs-and-crores-in-google-sheets)