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

Declaration

C#
VB.NET

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

<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.

Property Paths

You can access this nested property as listed below:

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

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:

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#
VB.NET

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);

pivot-chart-integration-how-to-show-a-waterfall-chart-control-t155168/CS/WindowsApplication53/Form1.cs#L54

DataRow row = intermediateDS.NewRow();
if (pivotGridControl1.OptionsChartDataSource.ProvideDataByColumns) {
    List<string> rowValues = new List<string>();

how-to-update-mvcxchartcontrol-control-according-change-made-in-the-attached-mvcxpivotgrid-t433948/CS/MvcPivotChartIntegration/Helper/PivotGridSettingsHelper.cs#L15


settings.OptionsChartDataSource.ProvideDataByColumns = false;
settings.ClientSideEvents.EndCallback = "PivotEndCallback";

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#L61

Dim result(2) As Object
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))

pivot-chart-integration-how-to-show-a-waterfall-chart-control-t155168/VB/WindowsApplication53/Form1.vb#L56

Dim row As DataRow = intermediateDS.NewRow()
If pivotGridControl1.OptionsChartDataSource.ProvideDataByColumns Then
    Dim rowValues As New List(Of String)()

how-to-update-mvcxchartcontrol-control-according-change-made-in-the-attached-mvcxpivotgrid-t433948/VB/MvcPivotChartIntegration/Helper/PivotGridSettingsHelper.vb#L14


settings.OptionsChartDataSource.ProvideDataByColumns = False
settings.ClientSideEvents.EndCallback = "PivotEndCallback"

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

PivotGridOptionsChartDataSourceBase.ProvideDataByColumns Property

Declaration

Property Value

Property Paths

Remarks

PivotGridOptionsChartDataSourceBase.ProvideDataByColumns Property

Declaration

Property Value

Property Paths

Remarks

Related GitHub Examples