How to format data label in 1000's for bar charts - to show data labels in K's

[Sajid_Mahmood]

How to format the data labels to be shown on the chart objects in 1000' format. Eg: 28,456 as 28k shown on the top of bar chart.

Please advise the solution urgently.

Thanks and Regards

Sajid Mahmood

[fernandotoledo]

I think you should make the calculation num(ceil(value/1000),'0k')

[sparur]

Hello.

Go to Number tab in chart properties.

and fill symbol in Thousand Symbol option = K.

you will see in Y-axes K symbol and numbers will be divided on 1000

[Sajid_Mahmood]

Hello

Thanks for your reply. Please note that I have asked for DATA LABELS Formating not x-axis or y-axis as suggested by you.

Please advise the solutions.