Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Type
Data, which provides four controls. These controls let you perform various
tricks on the data, as described in the following sections.
Switching rows and columns
The first control in the Data group, shown in the margin, is called Switch
Row/Column. It changes the orientation of your chart in a way that can be
difficult to describe but easy to visualize. Look back at the chart in Figure 13-4.
It’s based on the following data:
As shown earlier in Figure 13-4, the rows are used to determine the data
categories. Thus, the chart displays the data for Instruments, Music, Uniforms,
and Instruction along the horizontal axis.
If you click the Switch Row/Column button, the chart changes, as shown in
Figure 13-6. Here, the chart categorizes the data by city, so sales for River
City, Pixley, and Hootersville are shown along the horizontal axis.
Figure 13-6: Swapping the row/column orientation of a chart.