When there are multiple columns on the x- or y-axis or legend of a chart, you can reorder them by using the Configure Chart icon.
The order in which columns appear on the axis or legend is based on the sequence they are added. The first field is used as the primary sorting field for the chart. Adding another field adds it after the first one on the axis label or legend. If you want to change the order, you can remove the fields and re-add them in the reverse order.
This example shows you how to reorder the y-axis columns.
-
While viewing your answer as a chart, click the chart configuration icon
near the top right. -
Under Y-axis, drag and drop the column chips into your preferred order.
Your chart reorganizes itself to reflect the new label order.
