Microsoft Office Tutorials and References
In Depth Information
Switching Rows with Columns: A Different Kind of Change
in Figure 6–19. To change
the default chart, just click
the chart you want to
designate and click Set as
Default Chart. Then click OK,
and the chart you’ve chosen
will appear from now on
when you press F11.
Figure 6–19. Second thoughts: Where to reset your default chart
Switching Rows with Columns: A Different Kind of
Here’s another way to change your charts—one that doesn’t change chart types or their
colors, but rather does something very different. It’s called the Switch Row/Column
option . Switching a chart’s rows and columns flips the chart’s axes at right angles to
one another, so that the current data series switches places with the data on the
horizontal axis. For example, in our charts so far, the student names have occupied the
horizontal axis, and the subjects have served as the data series and appear in the
legend. By switching the row and column, the subjects will now populate the horizontal
axis, with the student names holding down the legend.
So why would you want to do this? To give the data a different perspective. Instead of
seeing how each student has performed in the three subjects—as with the original chart
setup—by switching row and column you can see how the four students’ grades are
bundled by each subject instead.
Now, if that still leaves you dazed and confused, actually trying the option out on our
chart should clarify.
Click the chart.
Turn it back to a column chart if you need to.
Click the Chart Tools tab and then the Design tab, and then click the Switch
Row/Column button in the Data button group. You’ll see what’s shown in