Working with pivot tables and creating charts

PivotTables provide an excellent tool for quickly analyzing data values from an Excel list or an external database by creating a cross-tabulated summary of the data values. With a PivotTable Report, you can dynamically customize which columns from the list that you want to summarize.






A PivotChart combines the dynamic, cross-tabulation ability of the PivotTable with the visual aspect of a chart. This allows you to dynamically analyze your data values in a chart format and to quickly spot any trend.
Although you can use PivotCharts with data from any source, they are best suited for smaller sets of data, because if you try to show too much data on a chart, it becomes difficult to interpret.