v
Chart Options:
 

Extended Price
Order Month(Ascending)[Filter]
Category Name(Ascending)[Filtered]
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberGrand Total
Beverages$20,308.45$49,149.56$37,444.99$38,175.25$30,149.60$18,988.95$3,485.42$11,071.72$10,703.80$10,815.10$16,346.26$21,229.06$267,868.16
Grains/Cereals$7,436.35$15,658.63$9,665.71$6,493.00$12,082.00$6,686.26$6,345.85$5,714.66$5,685.85$6,190.67$4,133.56$9,652.05$95,744.59
Grand Total$27,744.80$64,808.19$47,110.70$44,668.25$42,231.60$25,675.21$9,831.27$16,786.38$16,389.65$17,005.77$20,479.82$30,881.11$363,612.75

The chart showing Beverages series, Grains/Cereals series, Grand Total series.
Description
C#
VB
ASPX

The ASPxPivotGird allows data it displays to be visualized using the XtraCharts Suite. The ASPxPivotGrid provides data from the current selection and acts as a data source for other controls.

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 ASPxPivotGrid.OptionsChartDataSource.ChartDataVertical option. In this demo, this can be done via a configuration checkbox.

To exclude totals from the chart, turn off the OptionsChartDataSource.ShowColumnTotals, OptionsChartDataSource.ShowRowTotals and similar options.