When you selected the X and Y data for the line chart it saw it as two series, not as X and Y. Line charts should have the X axis categories in a header column, that is what Numbers prefers. When creating a line chart you only select the Y data and it uses the values in the header as the X axis. Scatter charts, on the other hand, want X and Y to NOT be in header columns and you select both to make the chart.
If you are okay with converting the first column to a header column:
- If the dates are in column A, convert it to a header column.
- Select the Y values in column B and make your chart.
If you do not want to convert A to a header column:
- Select only the Y values and make your chart.
- Click on the chart and go to the formatting sidebar, to the Axis tab and then to the X axis
- Where it says "label references", delete anything that is there then go to your table and select the cells that have your X axis data. This will make them the "label references" on the X axis.