Sorting in Windows Forms Pivot Chart

28 Apr 20211 minute to read

The pivot chart supports sorting of both PivotAxis and PivotLegends programmatically in the ascending and descending order. By default, the pivot chart populates the series in ascending order.

Sort by pivot axis

The pivot axis can be sorted by adding PivotSortDescriptor to the SortedAxis collection and ListSortDirection to specify the sorting order.

Here “Gender” is an PivotAxis item.

//Adding PivotAxis to the SortAxis collection for sorting.
this.pivotChart1.SortedAxis.Add(new PivotSortDescriptor("Gender", ListSortDirection.Ascending));
'Adding PivotAxis to the SortAxis collection for sorting.
Me.pivotChart1.SortedAxis.Add(New PivotSortDescriptor("Gender", ListSortDirection.Ascending))

Before applying sorting

Windows forms pivotchart displays before applied sorting on gender

After applying sorting on PivotAxis “Gender”

Windows forms pivotchart displays after applied the sorting on gender

Sort by pivot legends

PivotLegends can be sorted by adding PivotSortDescriptor to the SortedLegends collection and ListSortDirection to specify the sorting order.

Here, the “State” of PivotLegends item is FieldMappingName and the sorting order is ascending.

//Adding PivotAxis to the SortLegends collection for sorting.
this.pivotChart1.SortedLegends.Add(new PivotSortDescriptor("State"));
'Adding PivotAxis to the SortAxis collection for sorting.
Me.pivotChart1.SortedLegends.Add(New PivotSortDescriptor("State"))

Events

There are two events available in both SortedAxis and SortedLegends of pivot chart to handle or notify the sorting operation.

</table>
S.No Event name Details Event arguments
1 Changing Occurs before a property in a nested element or the collection is changed. PivotItemSortingEventArgs
2 Changed Occurs after a property in a nested element or the collection is changed. PivotItemSortedEventArgs