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 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member 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
    1. 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
      1. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064 > excelgraph
         
        Attention to properly respect the space between the 0 and the ".
        0
      2. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064 > tontong Posted messages 2575 Registration date   Status Member 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
    2. 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