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 entirely incorrect. It is most noticeable along the Horizontal axis where the data ranges from -1.32 to 2.69, but the graph has points plotted from 0-250. Absolutely no clue what is going on. I copied the points and pasted as values, and set the columns to numbers to see if there was a problem there but it made no difference.
6 Replies
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.
