adding a string in expression

[#1]

Hi all,

here am showing the total sales as 100,000,000.

I need this to show as 100M that is in millions, like

Thanks in advance

[#2]

Hi Remya

in tab "Numbers", you can check box Millions

best regards

chris

[#3]

Hi

   I did that already but its not showing like "100M"  as in the second chart i mentioned.

[Sokkorn]

Hi Remya,

Just right click on your chart -> Properties -> Number

Regards,

Sokkorn

[#5]

I did that, it will be like this

[Anonymous]

A very quick and dirty solution is to divide your expression by 1,000,000 and then put an 'M' on the end of the number format pattern in Chart Properties -> Number

Cheers,

Adam

[Anonymous]

Although saying that, I just tested it and the 'M' doesn't show on the axis.