Format number on data points as thousands

[guyvermeiren]

Hello,

I'm working on a bar chart where my axes are already formatted in thousands (K).

Now I would like to show the values on the the data points also as K-formatted values.

Anyone any idea ?

Thanks in advance

Kind regards,

Guy

[alexandros17]

Divide each expression by 1000

Hope it helps

[guyvermeiren]

Alessandro,

I want to keep my expressions for use in an other table.

I just want to change the format of the number to keep the logic with the axe-format.

Kind regards,

Guy

[alexandros17]

In Tab Number set K as Symbol and K as thousands symbol

[sudeepkm]

Have you tried like below?

[guyvermeiren]

Doesn't work.

The thing is that for example the number 427237 has to be shown (formatted) as 427K

Kind regards,

Guy

[alexandros17]

Try what I posted before and let me know please

[guyvermeiren]

K as thousands symbol OK.

But what do you mean by K as Symbol. Where do Iput that in Tab Number ??

[sudeepkm]

I thought you already have divided your expr with a 1000 and have the Number Format

Symbol: $

Thousands: K

Million: M

Billion: B

[alexandros17]

Here it is