Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal point in bar chart and similar
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal point in bar chart and similar
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. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal point | New Users to Excel | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
decimal point | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Why am I getting .+ when I hit the decimal point? | Excel Discussion (Misc queries) |