PivotGridControl.ChartProvideDataByColumns Property

Gets or sets whether series in a chart control are created based on PivotGrid columns or rows. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v18.2.dll

Declaration

C#

public bool ChartProvideDataByColumns { get; set; }

VB.NET

Public Property ChartProvideDataByColumns As Boolean

Property Value

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

Remarks

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

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

  

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

  

Related GitHub Examples

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

Note

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.

C#

how-to-visualize-pivot-grid-data-via-the-dxcharts-suite-e2913/VB/DXPivotGrid_ChartsIntegration/MainWindow.xaml#L21

<CheckBox.IsChecked>
    <Binding ElementName="pivotGridControl1" Path="ChartProvideDataByColumns"
             Mode="TwoWay" Converter="{local:InverseBooleanConverter}" />

how-to-show-data-from-the-dxpivotgrid-control-in-dxcharts-e2140/VB/ShowDatafromtheDXPivotGridControlinDXCharts/MainWindow.xaml#L15

                   HorizontalAlignment="Left" VerticalAlignment="Top"
                   DataSource="{Binding}" ChartProvideDataByColumns="True"  >
<dxpg:PivotGridControl.Fields>