Display in thousand

[#1]

Hello community,

I'm trying to display the values in a bar chart in thousand (k) eg. 132.000 in 132k. Is there a simple option instead of dividing through thousand. Searched similar community postings without any working version for me. Also tried number formating etc. in chart options.

Thanks for your help. Kind Regards

Aloah

[nagaiank]

In the Bar Chart properties, Number tab, add Thousand symbol, Million symbol, Billion symbol, etc.

Hope this helps.

[#3]

Hi tried that, unfortunately still shows 132000 instead of 132k.

[prieper]

If the display on the axis and the values on the datapoint shall be in the same dimension, think that you need to divide the results (in an expression) or the underlying values (in script) by 1Mio.

HTH
Peter

[#5]

If u want ur data to appear like the attached sample...then refer the points below:

I hve also done the same as u said ...

First divided the value by 1000.in expression and then

In Number tab>>Number format Settings:Number>>Format Pattern:

Paste

##,###,###K  here.

Hope ur problem is Solved.