Format numbers and 'Value on Data Points'

[Ferran_Garcia_Pagans]

Hi all,

I'm building a bar chart where I need to show the values of the bars ('Value on Data Points' option). I've formatted the numbers in this way.

The axes label changes depending on the unit, but the values don't change.

Does anybody knows how to control the format on these numbers?

Thanks, Ferran

[PrashantSangle]

Hi,

Follow Simple Step;

Go to Chart Property->Number->select Expression->Select Number Format Settings

->Format Pattern->Enter #,##0;#,##0

In above format Pattern #,##0;#,##0 in this  after ; it will format for -ve values,

Regards,