I'm trying to create a chart in Excel using scientific data. The charts I create are not behaving as expected. It is using all 4 columns of data for the Y axis and leaving the X axis blank. I want it to use the first column as the X axis. I know I can manually go in and change it, but I don't understand why. I usually don't have to do this. I've formatted the numbers of the 1st column to read as text, and still it won't use the first column as the X axis, or at least as a different axis from the other data.