pg电子太恶心

書名： .NET 4.0 Generics
作者名： David Lai Xavier Hacking
本章字數： 283字
更新時間： 2021-04-02 19:30:15

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.

There is more...

Besides sorting on category labels, it is also possible to sort by data. If you have more than one series, you have to choose one of these series to base the sorting order on.

The following chart shows the data shown in an ascending order:

官术网_书友最值得收藏!