Excel: Exchange X-axis and Y-axis in diagrams
With charts in Excel it is possible to swap the X and Y axes. This allows you to quickly change the entire display without having to create a second diagram.
Swap the X and Y axes - just press a button
- Select the diagram with a left click with the mouse. The new area "Diagram Tools" should now appear in the ribbon.
- Now click on the "Draft" tab and then on the "Change row / column" button.
- After changing the view, the diagram should look something like the second graphic.
After changing the view, the diagram should look something like the second graphic.
These instructions refer to Excel 2013. How to convert rows to columns and vice versa can be found here: Convert rows / columns