Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is it possible to display mouse-over values in Lakhs and crores, not in millions and billions

Hi,

Is there any way to show mouse-over values of the charts in lakhs & crores, not in millions and billions when i use a thousand seperator.

For example 100,000 should be displayed as 1,00,000.

Thanks,

Seshu.

Former Member
Former Member replied

Hi,

Found it.

Step 1: Format the required excel cells with this "[>=10000000] ##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00".

Step 2: Bind the cells to chart.

That's it, mouse-over values are automatically formatted.

Important: It has to be Step 1->Step2.

Thanks,

Seshu.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question