Chart Drill
Exercise 6: Switch rows and columns
Task
The bars are grouped by branch with months as series. Switch rows and columns so each branch is a series (the legend shows branches).
Moves 0 (target 1)
FileHome
| Branch | Apr | May | Jun |
| New York | 120 | 135 | 150 |
| Chicago | 90 | 80 | 110 |
| Seattle | 70 | 95 | 60 |
The bars are grouped by branch with months as series. Switch rows and columns so each branch is a series (the legend shows branches).
This drill is for computer screens. On a phone you can review the steps.
- Select the chart
- Chart Design > Switch Row/Column
Key takeaway
Swap the series (colors) and the horizontal axis items depending on what you want to compare.
See Excel Charts for details.