PivotGridDataSourceOptions.RetrieveDataByColumns Property

Specifies whether or not a Chart's series are created based on columns or rows of its associated Pivot Grid.

Namespace: DevExpress.XtraCharts

Assembly: DevExpress.XtraCharts.v20.1.dll


public bool RetrieveDataByColumns { get; set; }
Public Property RetrieveDataByColumns As Boolean

Property Value

Type Description

true if series should represent the Pivot Grid's columns; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to RetrieveDataByColumns
WinForms Controls ChartControl
ASP.NET Controls and MVC Extensions ChartControlSettings
Reporting XRChart


The RetrieveDataByColumns property is linked together with the PivotGridOptionsChartDataSourceBase.ProvideDataByColumns property of the associated Pivot Grid.


If the Chart's data source is not a Pivot Grid, trying to set this property causes a NotSupportedException, and the RetrieveDataByColumns property returns false when attempting to get its value.

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

See Also