Forum Discussion
Excel graphing incorrect values
I have some data in an excel sheet that is comprised of X and Y values and I am trying to plot them as a scatter plot. However, when creating the simple scatter plot the numbers it graphs are entirel...
I am seeing the same issue.
X data is RED. Why is it plotting as 1, 2, 3, 4... etc. It should be plotting the values themselves, correct?
I just solved my own problem. I think Excel was confused because of one of the X values having a typo. One value was written as "18..5" which has two decimal points. Because of that, Excel didn't interpret that column of data as numbers. It interpreted them as text, even though the other cells in the column were formatted as numbers. When I corrected the typo, the graph fixed itself automatically.
Good catch!
