Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.
A PivotChart is like a regular chart, except it displays data from a PivotTable. As with a regular chart, you'll be able to select a chart type, layout, and style to best represent the data. In this example, we'll use a PivotChart so we can visualize the trends in each sales region.
If you make any changes to the PivotTable, the PivotChart will adjust automatically.