Skip to main content

ChartControl.PivotGridSeriesExcluded Event

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

Namespace: DevExpress.XtraCharts

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

NuGet Package: DevExpress.Win.Charts


public event PivotGridSeriesExcludedEventHandler PivotGridSeriesExcluded

Event Data

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

Property Description
ActualSeriesCount Specifies the actual number of series as they appear in a Chart that is associated with a Pivot Grid.
AvailableSeriesCount Specifies the available number of series as they appear in a Chart that is associated with a Pivot Grid.


When a PivotGridControl) is assigned to the chart’s ChartControl.DataSource property, the maximum number of series that can be auto-created in the chart is limited by the PivotGridDataSourceOptions.MaxAllowedSeriesCount property value.


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

Handle the PivotGridSeriesExcluded event, to obtain both the current and total number of series (via the PivotGridSeriesExcludedEventArgs.ActualSeriesCount and PivotGridSeriesExcludedEventArgs.AvailableSeriesCount properties), e.g. to notify a user that the number of series has been forcibly limited.

To limit the number of points in a series, use the similar PivotGridDataSourceOptions.MaxAllowedPointCountInSeries property and the corresponding ChartControl.PivotGridSeriesPointsExcluded event handler.

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

See Also