Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.
PivotCharts are like regular charts, except they display data from a PivotTable. Just like regular charts, you'll be able to select a chart type, layout, and style that will best represent the data.
In this example, our PivotTable is showing each person's total sales per month. We'll use a PivotChart so we can see the information more clearly.
Try using slicers or filters to change the data that is displayed. The PivotChart will automatically adjust to show the new data.