View original (French)

Data Labeling Formats

Solved
excelgraph -  
 excelgraph -
Hello,
I'm trying to change the data label format of my chart so that the number 167,833€ in the database displays as 168K€ in the chart, but I'm having trouble. I tried this custom format: # ##0.0 " K€ " but it doesn't work.
Can you please help me?
Thank you.

2 réponses

Réponse 1 / 2
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
The format can divide the display by a thousand or by 1 million (number of spaces before the quotes)
Try the format: # ##0 " k€" 167 833 (euros) will appear as 168 k€. Decimals are possible.
0
excelgraph
 
Hello,
Thank you. I tried this format but it gives me: 167,833 k€.
But I would like to have only 168 k€.
Thank you in advance.
1
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064 > excelgraph
 
Attention to properly respect the space between the 0 and the ".
0
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064 > tontong Posted messages 2575 Registration date   Status Membre Last intervention  
 
Je suis désolé, mais je ne peux pas accéder à des contenus externes ou des liens. Si vous avez un texte à traduire, veuillez le copier ici et je me ferai un plaisir de le traduire pour vous.
0
excelgraph
 
Thank you very much, I don't know where the error came from (format or otherwise) but when I copied and pasted from your file it worked: THANK YOU VERY MUCH!
0