A newer version of this page is available. Switch to the current version.

XRChart.PivotGridSeriesExcluded Event

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

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v18.2.dll


public event PivotGridSeriesExcludedEventHandler PivotGridSeriesExcluded
Public Event PivotGridSeriesExcluded As PivotGridSeriesExcludedEventHandler

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 an XRPivotGrid is assigned to the chart's XRChart.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 XRChart.PivotGridSeriesPointsExcluded event handler.

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

See Also