PivotChart in Excel


Part PivotTable, part traditional Excel chart, a PivotChart lets you quickly and easily look at complex data sets in an easy-to-digest way. PivotCharts have many of the same functions as traditional charts, with data series, categories, and the like, but they add interactive filters so you can browse through data subsets.
pivot chart
PivotCharts help you easily digest complex data.
Excel 2013 added Recommended PivotCharts, which can be found under the Recommended Charts icon in the Charts area of the Insert tab. You can preview a chart by hovering your mouse over that option. You can also manually create a PivotChart by selecting the PivotChart icon on the Insert tab..