Changing the column order on an axis

It is possible to change the order of columns on an axis by dragging the columns to other positions.

For example, in the bar chart below, three columns are selected on the category axis.

Switched columns in hierarchy
If you for example drag the Year column to the left, the bar chart changes accordingly as shown below.
Switch column order

Hierarchy on axis

Prerequisites

More than one column are selected on an axis.

Procedure

  • Specify the order of the columns on the axis by dragging them to the wanted positions.