Whenever I have a decimal point in my data, the point on the graph drops down to 0 in the Y-axis.
What could be causing this? It is unusual behaviour, right?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
This happens when the numbers use a different decimal symbol than the one specified in Windows regional settings, which causes those numbers to be interpreted as text.
In my case, the system language had recently been set to French, which uses comma (,) as the decimal symbol, while the numbers in Excel used the period (.). Changing the numbers in Excel and replacing periods with commas fixed the problem.