PivotGridSettings.CustomChartDataSourceRows Property

Allows you to customize pivot grid data before passing it to a chart control.

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v24.2.dll

Declaration

C#

public PivotCustomChartDataSourceRowsEventHandler CustomChartDataSourceRows { get; set; }

VB.NET

Public Property CustomChartDataSourceRows As PivotCustomChartDataSourceRowsEventHandler

Property Value

Type	Description
PivotCustomChartDataSourceRowsEventHandler	A PivotCustomChartDataSourceRowsEventHandler delegate method allowing you to implement custom processing.

Remarks

The CustomChartDataSourceRows event occurs before a PivotGrid 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.

PivotChartDataSourceRowBase.Argument	Gets or sets the argument of a chart point that will represent the current datasource row.
PivotChartDataSourceRowBase.Series	Gets or sets the series of a chart point that will represent the current datasource row.
PivotChartDataSourceRowBase.Value	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.

PivotChartDataSourceRow.CellInfo	Gets information about a pivot grid cell that corresponds to the current datasource row.
PivotChartDataSourceRow.ColumnValueInfo	Gets information about the column field value that corresponds to the current datasource row.
PivotChartDataSourceRow.RowValueInfo	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.