To determine how your worksheet information is presented in the chart, you can choose whether Excel charts the columns of your worksheet or the rows. This is done in the Chart Wizard by clicking the Chart Wizard button and then clicking the Next button.
In the picture, the chart on the left compares the salespeople to each other, month after month. Excel selected the worksheet rows as the data series.
The chart on the right shows the monthly performance of each individual salesperson. In this chart the data series charted is the worksheet columns.
Tip You can also select what to chart by clicking either the By Rows button or the By Columns button on the Chart toolbar.