Decimal point in bar chart and similar

S

Safe Tex

Hello

I recently had to translate a document and after replacing all the French decimals (a comma) with the English decimal dot (a period), I lost the bars in the graph.

This got me wondering if graphs in Excel do not necessarily display correctly depending on the formatting of the data series and the local language settings of the computer which has downloaded the document.

It would seem mad that this is so but after my experience...

Can anyone confirm or refute this idea?

Thanks
 
C

Claus Busch

Hi,

Am Sun, 4 Jan 2015 23:07:54 -0800 (PST) schrieb Safe Tex:
I recently had to translate a document and after replacing all the French decimals (a comma) with the English decimal dot (a period), I lost the bars in the graph.

This got me wondering if graphs in Excel do not necessarily display correctly depending on the formatting of the data series and the local language settings of the computer which has downloaded the document.

if the values in the french document are real numbers the format would
be modified to your language settings while opening. If not the values
are text and they remain text if you search and replace the separator.
Write 1 in a empty cell, copy this cell, select your data and Paste =>
Paste special => Multiply to change the values to real numbers.


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top