View original (French)

Data labels divided by 10 in graphs

Nolwn Posted messages 3 Status Member -  
JvDo Posted messages 1924 Registration date   Status Member Last intervention   -
Hello,

Since I installed the 2010 version of Excel on my PC, I've been having an issue with data labels on charts (bar charts): they are automatically divided by a multiple of 10.

For example: my values are 89 / 93 / 91 --> the data labels display 8.9 / 9.3 / 9.1
whereas the axis display is correctly between 70 and 110.

Thank you in advance for your replies :-)

Nolwn'

Configuration: Windows 7 / Chrome 47.0.2526.106

2 answers

  1.
    JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
     
    Hello,

    upload your file on cjoint

    best regards
    0
    1. Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   17 490
        
       1) Go to https://www.cjoint.com/ 
       2) Click on [Browse] to select your file (max 8192 Ko)
       3) Scroll down to click on the blue button [Create Cjoint link] 
       4) After a few seconds, the second page will appear, with the link in bold; select it and click "Copy"
       5) Go back to your discussion on CCM, and in your reply message, click "Paste".
      =>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
      0
    2. Nolwn Posted messages 3 Status Member
       
      Hello,

      Here is the link: http://www.cjoint.com/c/ELxiqFMv3Wu

      I have the issue only for two of the 4 histograms (WEIGHT and ICT are okay, but GMQ and CMJ are misaligned).

      Another strange thing: when I try to add a decimal to the data for WEIGHT, the problem appears in my corresponding graph. And it disappears if I add a second decimal. If I add 3, my data are divided by 1000.

      Best regards,
      NB.
      0
      1. JvDo Posted messages 1924 Registration date   Status Member Last intervention   859 > Nolwn Posted messages 3 Status Member
         
        Hello,

        You need to format it with a point instead of a comma, like "0.000".
        That's why it seems like your labels are divided by 1000.

        Set it to number format and choose the number of decimals.
        It works fine for me this way.

        Best regards
        0
  2. Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   17 490
     
     Quick check:

    Right-click on a label
    Format Data Labels
    In the left pane choose Number
    In the right pane choose General

    --
    Retirement is nice! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    0
    1. Nolwn Posted messages 3 Status Member
       
      Hello,
      By default, everything is set to "general"!
      The problem arises when I want to add/remove a decimal in my data source, it doesn't reflect in the data labels.
      0