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.

Naming Basics Best practice recommendations are to create a chart placing independent variables on the horizontal, x-axis and dependent variables on the vertical, y-axis.