Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had chart city, sales.
in sales column values are,
100000,
2340000,
2345600
how to show these values in million in chart like
1M,
2.34M,
2.3456m,
Hi,
=sales/1000000 & 'M'
Hope it works
Hi,
you have the option to override the number format within the chart properties (see attached), this can be done for each expression. The other option you have is to use Num() in your expression and use the second parameter to set the format
hope that helps
Joe
Hi joe,
i did'nt understand how to get that.
can u plz modify this attachment.
thanks
Like this :
Hi,
Please check this attached file for solution.
Regards,
Jagan.