How to get excel to use specified x values for scatter instead of counting whole numbers 0,1,2,3

Mike M 0 Reputation points
2023-07-12T15:30:08.6933333+00:00

Hello all,

I am trying to create a scatter plot of stress (y) v strain (x) from a csv file that I obtained through a load cell but excel will not use the x data I specified. It just assigned 0,1,2,3... to each y-value. I have double checked that the series are the same length and that all values are number format. It just seems to have a mind of its own. I have attached a screenshot of the plot as it is showing currently, and an example of what the data should look like. Not sure if I can send the real excel file with my company's restrictions.

Please help!

Thank you

Stress v Strain Scatter Issue

Screenshot 2023-07-12 112912

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,075 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.