Skip to main content

ChartControl.PivotGridSeriesPointsExcluded Event

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

Namespace: DevExpress.XtraCharts

Assembly: DevExpress.XtraCharts.v22.1.UI.dll

NuGet Package: DevExpress.Win.Charts


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 a PivotGridControl is assigned to the chart’s ChartControl.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 PivotGridSeriesPointsExcludedEventArgs.ActualSeriesPointCount and PivotGridSeriesPointsExcludedEventArgs.AvailableSeriesPointCount 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 ChartControl.PivotGridSeriesExcluded event handler.

For more information, see Pivot Charting (Integration with a Pivot Grid Control).

See Also