Sorting series
A chart does not always look like what you had in mind. In some cases, you may want to see data sorted from high to low values, while in other situations, you want to see the categories to be displayed in a more logical order. For example, in the following bar chart, the quarters are sorted from last (Q4) to first (Q1). To change this, you can of course adjust the data model in the spreadsheet, like we did in the Using the OHLC chart and Candlestick chart recipe. An easier and better way is to use the Sorting settings for the bar chart component.
Note
Sorting is available in the following components: line chart, pie chart, column chart, stacked column chart, bar chart, stacker bar chart, combination chart, area chart, stacked area chart, radar chart, and the filled radar chart.
Getting ready
You can reuse any of the dashboards you created earlier, as long as they contain one of the components listed above.
How to do it...
- Select the component, go to the Behavior tab, and select the sub-tab Common.
- Select Enable Sorting.
- Select By Category Labels.
- Select Reverse Order.
How it works...
As you can see in the previous screenshot, the order of the quarters has changed. In Dashboard Design, the first category is by default the lowest category on its axis. With the reverse order setting, this can be changed.
