Forum Discussion
Excel graphing incorrect values
Click in the chart.
On the Chart Design tab of the ribbon, click Select Data.
Select the series, then click Edit.
Has the 'Series X Values' been set to the correct range?
If not, specify the correct range.
If not, close the dialog, then select the range with X-values.
Make sure that the number format is set to General or to Number.
If this is in a column, click Text to Columns on the Data tab of the ribbon, then click Finish.
Does that make a difference?
No it did not help: the scatter plot is replacing somehow the value in the x-axis with the entry number...
Microsoft products have become so cumbersome and prone to these kinds of glitches. Quite unacceptable in my opinion.
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.
