If you instead make a chart from multiple rows and multiple columns, Excel will make one dimension the x-axis and make the other into different series.

This article explains how to add a secondary axis to a chart in Excel so you can view unlike categories on the same graph. These instructions work in Excel in Microsoft 365, Excel 2021, Excel 2019 ...

Scatter charts use two columns of data for each point. By default, Excel will use the first column for the X coordinate and the second for the Y coordinate. To add additional data for the Y axis ...