Pivot chart control allows users to analyze their data through the view. It differs from normal charts by showcasing additional information in the chart, which will allow users to group or customize chart data through interactive functionalities like sorting, filtering, etc.
Through expanders, users can drill-down to next level of hierarchy and drill-up to the previous level.
Pivot chart can be rendered through different chart types based on the need. Supported chart types are line, spline, column, area, spline area, stacking area, stacking column, stacking area 100, stacking column 100, step line, and step area. Users can also easily switch among different chart types dynamically. Fields bound to a chart will be automatically transformed into the target chart type.
Pivot chart can be dynamically built and customized by choosing any available fields to display and whether those fields should be displayed as column, row, value, or filter fields. The pivot table field list also has the flexibility to wire itself with both pivot chart and pivot grid. This will link the pivot grid and pivot chart. Your user can make changes to one control and that change will occur on the other control.
The visual look and feel of pivot chart can be enriched through the use of various built-in skins like Metro, Almond, Blend, etc., and Office themes.
Pivot chart provides support to sort the
Pivot chart provides support to refresh the chart area automatically when the data is updated in the underlying data source.
Pivot chart has print and print preview available for your printing needs.
Users can export pivot data to Excel. This export will include the data and create a pivot chart in the Excel workbook.
Users can zoom and scroll the pivot chart. Zooming can be enabled for just one or both axes.