<< Click to Display Table of Contents >> Swap Row Column Header/Row and Column Axis |
![]() ![]() ![]() |
The pivot and chart components support changing the display format of the data by swapping the row and column header/Row and Column axis.
❖Swap row column header: Used to swap the position of row headers and column headers in pivot.
➢For Example: Swap the row and column header of the pivot below.
Click the "Swap Row Column Header" button to exchange the position of the row header and column header, as shown in the figure below.
❖Swap Row Column: Used to exchange the positions of the Row and Column axis in the chart.
➢For Example:Swap the Row and Column axis of the chart below.
EE
Click the "Swap Row&Column" button to swap the positions of the Row and Column axis. The effect is shown in the figure below.