The Pivot Grid presents multidimensional data in a cross-tabular form, allowing end-users to perform various data shaping operations. They can customize the report to reshape data and create a layout that fits their specific data analysis needs.
ASPxPivotGrid allows end-users to go further and visualize data displayed in the Pivot Grid using the Chart Control.
Series and argument data members are created based on column/row headers (e.g., '1994', 'Produce Total', 'Grand Total'). If a column/row is identified by multiple fields, the corresponding data member value is constructed from the respective field values connected by the '|' sign (e.g., '1995 | January', 'Beverages | Chai').
To set an ASPxPivotGrid as the WebChartControl data source, do one of the following:
At design time, click the WebChartControl smart tag and select the ASPxPivotGrid instance from the Choose Data Source drop-down list:
When the ASPxPivotGrid.ID property is assigned to the ASPxDataWebControlBase.DataSourceID property, the chart bindings and layout are auto-adjusted.
If necessary, you can manually specify WebChartControl binding settings that define how to create a diagram from supplied data. There are two modes of providing binding settings to ChartControl: automatic and manual. You can specify which one to use via the WebChartControl.AutoBindingSettingsEnabled property.
In automatic mode (the WebChartControl.AutoBindingSettingsEnabled property is set to true), binding settings are automatically adjusted. In this instance, WebChartControl uses data source series, argument and value data members to create series, arguments and values, respectively. You can manually adjust automatically applied binding settings by handling the WebChartControl.CustomizeAutoBindingSettings event. This event is raised when automatic settings are about to be applied to the WebChartControl.
When binding settings are applied, you can manually specify layout settings that define how to display the diagram. As with binding settings, you can let WebChartControl adjust these settings automatically (in this instance, you can manually customize them by handling various events) or specify them manually. Use the WebChartControl.AutoLayoutSettingsEnabled property to specify whether or not layout settings are automatically adjusted.
For a list of binding and layout settings, see the Pivot Charting topic in the Chart Control documentation.