Microsoft Office Tutorials and References
In Depth Information
Switching rows and columns
Switching rows and columns
Most of the time when you present a block of data to Excel for charting, the program
figures out correctly how to organize that data—which labels to assign to the horizontal axis
and which to put in the chart’s legend. Because this might not always be the case, however,
the program offers a Switch Row/Column button in the Data group of the Design tab.
Clicking that button, for example, transforms this chart:
Search JabSto ::




Custom Search