Format # in Bar Chart

[#1]

I have a bar chart where the values are  displayed like 73,682,960.  How do I format the number to display 73.68?

[#2 · Accepted solution]

Under your Chart Properties - "Number" tab:

- Enter something into  the field "Million Symbol", eg. enter "M"

If this does not work then you could also simply divide your result by 1,000,000 and change the format pattern to add the appropriate format designation.

[jagan]

Hi,

In Number tab give Million Symbol as you wish for the expression or else divide the number by 1000000.

Hope this helps you.

Regards,

Jagan.