cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

former_member182541
Active Contributor
0 Kudos

No its not possible either its default format or the thousand separator.