Excel Scatter Plot Date Axis Not Working. Make sure that the cells you are referencing as axis labels are text. Make sure Text axis.
THEN in the horizontal axes additional formatting dialogue click axes options under axis type. I have already checked that the data in the left column is listed as number. The x axis numbers also dont coordinate with the data I selected.
First make sure you are using a Scatter chart rather than a Line chart.
The Y axis data ranges from 250 to 400 yet it is all 0. The x axis data ranges from 15 to 40 yet theres are several markers that show x being less than 15. Instead it does something stupid and my scatter plot is just a straight line at the bottom of the graph where y 0. To make the x-axis consider the values as text.
