Data labels divided by 10 in graphs
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
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
-
Hello,
upload your file on cjoint
best regards-
Contributor
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 -
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. -
@NolwnHello,
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
-
-
Contributor
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)
