XRChart.PivotGridSeriesPointsExcluded Event

Occurs after a chart has been bound to a Pivot Grid.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v21.1.dll


public event PivotGridSeriesPointsExcludedEventHandler PivotGridSeriesPointsExcluded

Event Data

The PivotGridSeriesPointsExcluded event's data class is PivotGridSeriesPointsExcludedEventArgs. The following properties provide information specific to this event:

Property Description
ActualSeriesPointCount Specifies the actual number of points in a series of a Chart that is associated with a Pivot Grid.
AvailableSeriesPointCount Specifies the available number of points in a series of a Chart that is associated with a Pivot Grid.
Series Gets an auto-created series, for obtaining both its actual and total number of points.


When an XRPivotGrid is assigned to the chart’s XRChart.DataSource property, the maximum number of points allowed for an auto-created series is limited by the PivotGridDataSourceOptions.MaxAllowedPointCountInSeries property value.


A zero value for this property specifies that the number of points is not restricted.

Handle the PivotGridSeriesPointsExcluded event, to obtain both the current and total number of points (via the PivotGridSeriesExcludedEventArgs.ActualSeriesCount and PivotGridSeriesExcludedEventArgs.AvailableSeriesCount properties), e.g. to notify a user that the number of points has been forcibly limited. An auto-created series can be accessed via the PivotGridSeriesPointsExcludedEventArgs.Series property.

To limit the number of series in a chart, use the similar PivotGridDataSourceOptions.MaxAllowedSeriesCount property and the corresponding XRChart.PivotGridSeriesExcluded event handler.

To learn more, see Pivot Charting (Integration with a Pivot Grid Control).

See Also