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.v19.1.Core.dll

Declaration

C#

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

VB.NET

<DefaultValue(True)>
<XtraSerializableProperty(-100)>
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 Web Forms Controls	ASPxPivotGrid	.OptionsChartDataSource.ProvideDataByColumns
	MVCxPivotGrid	.OptionsChartDataSource.ProvideDataByColumns
	PivotGridSettings	.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:

  

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