PivotGridOptionsChartDataSourceBase.ProvideDataByColumns Property

Gets or sets whether series in a chart control are created for PivotGrid columns or rows.

Namespace: DevExpress.XtraPivotGrid.Data

Assembly: DevExpress.PivotGrid.v21.2.Core.dll


public bool ProvideDataByColumns { get; set; }

Property Value

Type Default Description


true if PivotGrid columns are represented by series in a chart control; false if PivotGrid rows are represented by series in a chart control.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to ProvideDataByColumns
WinForms Controls PivotGridControl
Reporting XRPivotGrid
ASP.NET MVC Extensions MVCxPivotGrid
ASP.NET Web Forms Controls ASPxPivotGrid


In the following images, a Chart control displays data from a PivotGridControl, with the ProvideDataByColumns property set to true and false, respectively.

  • ProvideDataByColumns = true. Pivot Grid columns are represented by series in the Chart control:


  • ProvideDataByColumns = false. Pivot Grid rows are represented by series in the Chart control:


The following code snippets (auto-collected from DevExpress Examples) contain references to the ProvideDataByColumns property.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also