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.

Descriptive labels on an Excel chart enhance its readability and help you interpret the information the chart contains. Whether naming comes in the form of text, numbers or a combination, both the x ...