For some reason Google Spreadsheet insists on using the data I wish to have for my x-axis as my y-axis. Here I'll show what happens when I try to use my data to form a chart, and what happens when I use Google's example data for creating a line chart.Here is the image (my data is on the right, example data on the left):
Google Spreadsheets mixing up x- and y-axis on line chart, no option to change it
google spreadsheets;graph