Reversing the Series and Categories of a Chart in Excel 2007:-

Excel follows strict rules in deciding whether rows should be series or categories. Luckily, you can reverse this decision with a single button click.

If Excel chooses the wrong orientation for the data in a chart, you can click the Switch Row/Column icon in the Design ribbon. Compare the before and after charts in the Figure (given below). You will see that the years have changed from being category labels to being series labels. The products have changed from being series labels to being category labels.



(To reverse the orientation of data in a chart, you click Switch Row/Column.)

If your data has more columns of data than rows, the headings in the first row become category labels. In the Figure (given below), the eight columns of monthly data become category labels, and the three rows become series.



(If your data has more columns than rows, the rows become series in the chart.)

If your data has more rows than columns, the headings in the first column become category labels. In Figure (given below), the 11 rows of city data become category labels, and the 4 columns become series.



(If your data has more rows than columns, the columns become series in the chart.)

If your data has exactly the same number of rows and columns, the rows become series.