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.

How to Make Your Graph to the Same Scale on a Vertical & Horizontal Axis in Excel. When you create a graph in Excel, the software automatically sizes the X and Y axis lines, so the data you want ...