Allows you to customize pivot grid data before passing it to a chart control.
NuGet Package: DevExpress.Wpf.PivotGrid
public event PivotCustomChartDataSourceRowsEventHandler CustomChartDataSourceRows
Public Event CustomChartDataSourceRows As PivotCustomChartDataSourceRowsEventHandler
The CustomChartDataSourceRows event's data class is PivotCustomChartDataSourceRowsEventArgs. The following properties provide information specific to this event:
|Rows||Gets the collection of chart datasource rows.|
The event data class exposes the following methods:
|CreateRow(Object, Object, Object)||Creates a PivotChartDataSourceRow instance that specifies a chart’s series point with the specified argument, series and value.|
The CustomChartDataSourceRows event occurs before PivotGridControl passes its data to a bound chart control.
Use the event parameter’s PivotCustomChartDataSourceRowsEventArgs.Rows property to access data that will be passed to the chart.
This collection contains PivotChartDataSourceRow objects that identify chart datasource records. Each record contains data from a specific pivot grid cell and will be represented by a series point in a chart.
Use the following properties, exposed by the PivotChartDataSourceRow objects, to obtain and modify the point’s argument, series and value.
Gets or sets the argument of a chart point that will represent the current datasource row.
Gets or sets the series of a chart point that will represent the current datasource row.
Gets or sets the value of a chart point that will represent the current datasource row.
For each record, you can also obtain information about a pivot grid cell to which this record corresponds. To do this, use the following properties.
Gets information about a pivot grid cell that corresponds to the current datasource row.
Gets information about the column field value that corresponds to the current datasource row.
Gets information about the row field value that corresponds to the current datasource row.
Use the PivotCustomChartDataSourceRowsEventArgs.CreateRow method to create PivotChartDataSourceRow instances. You can then add them to the PivotCustomChartDataSourceRowsEventArgs.Rows collection using its Add and Insert methods.