Pivot chart

A pivot chart is a data analysis tool that enables one to visualize a pivot table. It is a built-in feature of Microsoft Excel and Microsoft Access. The single word PivotChart is a trademark of Microsoft Corporation.

Overview

PivotChart is best type of graphs for the analysis of data. The most useful feature is the possibility of quickly changing the portion of data displayed, like a PivotTable report. It makes PivotChart ideal for presentation of data in the sales reports.

Pivot chart for Microsoft Excel

• A pivot chart can be copied and pasted within Excel ^[1]or among other Microsoft Office software.

Pivot chart for Microsoft Access (v. 2010 and previous)

• Microsoft Access (v. 2010 and previous) can create "multi-plots" from a shared dataset. For example, from a table of students' student ID, math score and gender, a page can be created consisting of multiple charts where two charts (student ID/math score) are generated for female and male students side by side. This function is not supported by Microsoft Excel.
• Pivot charts cannot be copied and pasted in Microsoft Access.

References