Define a custom sort order for a Worksheet
You can define a custom sort order for a worksheet to sort charts in a specific order based on your business needs.
The following chart types are supported:
-
Table
-
Column
-
Stacked column
-
Line
-
Bar
-
Stacked Bar
-
Line Column
-
Area
-
Stacked Area
-
Line stacked Column Scatter
-
Bubble,
-
Waterfall
-
Funnel
-
Pie
-
Heatmap
To define a custom sort order for a Worksheet:
-
Select Data on the top navigation bar.
-
Select the Worksheet you want to edit.
-
Go to the Custom Sort column and enter the data elements that you want to sort on.
![Custom sort order](_images/custom-sort-order.png)
Users can apply the sort order to any answer, using the search keyword sort by …, or using the sort options on the axis menu.
Users can switch between Alphanumeric and Custom sort order in the Edit Column Properties menu.