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.v22.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design

Declaration

C#

[DefaultValue(true)]
public bool ProvideDataByColumns { get; set; }

VB.NET

<DefaultValue(True)>
Public Property ProvideDataByColumns As Boolean

Property Value

Type	Default	Description
Boolean	true	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 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:

  

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ProvideDataByColumns 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-xtracharts-suite-e2912/CS/ASPxPivotGrid_ChartIntegration/Default.aspx.cs#L12

// Specifies that Series data member values are created based on columns.
ASPxPivotGrid1.OptionsChartDataSource.ProvideDataByColumns = true;

how-to-mediate-a-pair-of-bridged-chart-and-pivot-grid-with-a-filter-control-e2597/CS/Form1.cs#L43

private void InitializeMenuItemsState() {
    chartDataVerticalToolStripMenuItem.Checked = pivotGridControl1.OptionsChartDataSource.ProvideDataByColumns;
    selectionOnlyToolStripMenuItem.Checked = pivotGridControl1.OptionsChartDataSource.SelectionOnly;

how-to-create-a-custom-chart-data-source-e2520/CS/CustomChartDataSourceWin/CustomChartDataSource.cs#L56

object[] result = new object[3];
result[0] = string.Concat(fPivot.OptionsChartDataSource.ProvideDataByColumns ? GetFieldValue(cell, false) : GetFieldValue(cell, true),
    fPivot.GetFieldsByArea(PivotArea.DataArea).Count > 1 ? string.Concat(" | ", cell.DataField.Caption) : string.Empty);

VB.NET

how-to-visualize-pivot-grid-data-via-the-xtracharts-suite-e2912/VB/ASPxPivotGrid_ChartIntegration/Default.aspx.vb#L14

' Specifies that Series data member values are created based on columns.
ASPxPivotGrid1.OptionsChartDataSource.ProvideDataByColumns = True

how-to-mediate-a-pair-of-bridged-chart-and-pivot-grid-with-a-filter-control-e2597/VB/Form1.vb#L45

Private Sub InitializeMenuItemsState()
    chartDataVerticalToolStripMenuItem.Checked = pivotGridControl1.OptionsChartDataSource.ProvideDataByColumns
    selectionOnlyToolStripMenuItem.Checked = pivotGridControl1.OptionsChartDataSource.SelectionOnly

how-to-create-a-custom-chart-data-source-e2520/VB/CustomChartDataSourceWin/CustomChartDataSource.vb#L59

Dim result As Object() = New Object(2) {}
result(0) = String.Concat(If(fPivot.OptionsChartDataSource.ProvideDataByColumns, GetFieldValue(cell, False), GetFieldValue(cell, True)), If(fPivot.GetFieldsByArea(PivotArea.DataArea).Count > 1, String.Concat(" | ", cell.DataField.Caption), String.Empty))
result(1) = If(fPivot.OptionsChartDataSource.ProvideDataByColumns, GetFieldValue(cell, True), GetFieldValue(cell, False))