Page 543 - Excel 2013 All-in-One For Dummies

Worksheet Charting 101 525
Figure 1-6:
Clustered column chart on its own chart sheet after selecting a new layout and style from the Design tab.
Switching the rows and columns in a chart
Normally when Excel creates a new chart, it automatically graphs the data by rows in the cell selection so that the column headings appear along the horizontal (category) axis at the bottom of the chart and the row headings appear in the legend (assuming that you’re dealing with a chart type that uti- lizes an x- and y-axis).
You can click the Switch Row/Column command button on the Design tab of the Chart Tools contextual tab to switch the chart so that row headings appear on the horizontal (category) axis and the column headings appear in the legend (or you can press Alt+JCW).
Figure 1-7 demonstrates how this works. This figure shows the same clus- tered column chart after selecting the Switch Row/Column command button on the Design tab. Now, column headings (Qtr 1, Qtr 2, Qtr 3, and Qtr 4) are used in the legend and the row headings (CD Sales, Rock, Jazz, Classical, and Other) appear along the horizontal (category) axis.
Book V Chapter 1
Charting Worksheet Data