Axis Number Format

[manojkulkarni]

Hi Team,

I would like to change the display numbers in Axis to specific format. How can we achieve this ?

Always the representation is fixed to thousand separator. I would like to change as per geography.

[avinashelite]

Go to Chart properties and Number tab, here you should get the option to do.

OR even you can do it using the NUM() function too

[manojkulkarni]

I have tried both the options, it doesn't work. If working for you pls send me working app.

[MarcoWedel]

please post an example app and your format requirements.

thanks

regards

Marco

[manojkulkarni]

Pls find attached sample.

Value on Bar is in different format and format of axis is different. Would like to have same number format on Axis as well

[avinashelite]

Please find the attachment for the solution :

[Frank_Hartmann]

i think you cant use the Barchart format "#.##.##0" also on your axis.

try to change the value of one of your inlinetable data to >1000000 (e.g Blore=8000000)

and you wont get shown the correct data in chart because the format does not fit!