Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Basic Chart Integration

Order Year[Filter]
Show filter builder dialog[Category Name] Is any of ('Beverages', 'Grains/Cereals') Clear
The chart showing Beverages series, Grains/Cereals series, Grand Total series.
Chart Settings

The ASPxPivotGrid allows visualizing data displayed in the Pivot Grid using the XtraCharts Suite. By default, the WebChartControl displays all data of the ASPxPivotGrid control.

If you chart data horizontally, the WebChartControl uses row values as series and column values as arguments, or vice versa if you want to visualize data vertically. To specify how data is interpreted in a chart, use the PivotGridOptionsChartDataSourceBase.ProvideDataByColumns property. In this demo, this can be done via a configuration checkbox.

To exclude totals from the chart, turn off the PivotGridOptionsChartDataSourceBase.ProvideColumnGrandTotals, PivotGridOptionsChartDataSourceBase.ProvideRowGrandTotals and similar options.

See Also:
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos