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...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Alternatively, you can attach it to a private message to me. Thanks in advance.
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!