Pivot Chart

## Pivot Chart Document Solutions for Excel allows you to create a PivotChart in worksheet. PivotCharts provide graphical representations of the data in their associated PivotTables. PivotCharts are also interactive. When you create a PivotChart, the PivotChart Filter Pane appears. You can use this filter pane to sort and filter the PivotChart's underlying data. Changes that you make to the layout and data in an associated PivotTable are immediately reflected in the layout and data in the PivotChart and vice versa. PivotCharts display data series, categories, data markers, and axes just as standard charts do. You can also change the chart type and other options such as the titles, the legend placement, the data labels, the chart location, and so on. - Create a normal chart first. - Then call **IChart.SetSourceData(IRange source)** to turn a normal chart into a PivotChart when **source** is inside a pivot table's range.