Comma Style in chart title

[Anonymous]

Good Day All,

I am trying to apply comma style in chart title, see the attachment but failed. However it worked in one chart !

, '#,##0')         As far as I know, this is the comma style format, but is it applicable to all styles!! example:

                      Loss= 45411               after comma = 45,411  

                      Profit= 1283987363      after comma = 1,283,987,363 

,'#,##0.0%')      As far as I know, this is the percentage format

Kindly explain both styles, how to apply comma's to any number in chart title. Thanks alot.

Alfie,

[jonathandienst]

You may need to supply the optional parameters too:

     Num(....., '#,##0', '.', ',')

HTH

Jonathan

[Anonymous]

Thanks Jonathan,

Could you elaborate further. Where is the optional parameter located?
Note, I am using Chart title under General tab to display the figures.  Thanks

[Agis-Kalogiannis · Accepted solution]

Hi

In order to change the format of the number, you need to use the NUM() function.

An example would be:

num(count(Orders), '#,##0')

and this would give you a comma separated integer in the for or 1,253,423 as you mention above.

A different example:

num(sum(Sales), '#,##0.0%') will give you a percentage with one decimal point.

[#5]

'$#,##0'

If you need to express in dollar format, i.e. - with a $ sign, you add $ sign in the beginning (just like above)