Microsoft Office Tutorials and References
In Depth Information
Working with Chart Data
A chart with quarters as the series
A chart with regions as the series
To switch back and forth between plotting by rows and by columns in the data sheet, click
the Switch Row/Column button on the Chart Tools Design tab. If the button is not available,
open the data sheet by choosing Chart Tools Design
Edit Data, and then the but-
ton will become available.
A chart can carry a very different message when you arrange it by rows versus by columns.
For example, in Figure 12.5, the chart compares the quarters. The message here is about