Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2015 at 12:12 PM

    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.


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 07:16 AM

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

    Add comment
    10|10000 characters needed characters exceeded