Sorting Chart labels

Non-fact items can be sorted in the Chart section by leveraging the same sorting options and techniques used with Pivots. The Sort line is toggled on and off by clicking on the Sort button at the top of the Section Title Bar. An example of the Sort line is shown in the following screenshot:

The Sort line contains three drop-down boxes. The first is for selecting the non-fact item to sort and the second is the column to use to sort the label. The default sort column is Label, which refers to sorting the data by the physical label name. The third drop-down box is for the selection of the data function to use when sorting the labels by a fact column. If the Label option is selected, the third drop-by-box is disabled. However, when a fact column is selected, the third drop-down box is enabled and a data function must be selected for the aggregation of data in the sort with Sum set as the default.