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

Answer 1 / 2
JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
 
Hello,

upload your file on cjoint

best regards
0
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
  
 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
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
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
Answer 2 / 2
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
 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
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