Creating PivotCharts

Microsoft Access 2010 continues to provide support for Access PivotCharts. PivotCharts can be a great way to provide users with a visual representation of data, and is often used to represent sets of data for easy visual comparison. PivotCharts are a great way to spruce up your forms and reports, because almost every database has some kind of data that can be charted. Best of all, PivotCharts in Access 2010 can be built with just a few clicks of the mouse!


To begin this lesson, it is assumed that you have at least some limited knowledge of how to design forms in Access 2010. This lesson discusses how to build PivotCharts, which are essentially a certain type of form in Access. However, this lesson does assume that you have no prior knowledge of building Access PivotCharts.


Several methods exist for creating PivotCharts in Access. The most common method is to simply choose the PivotChart button from the Create Ribbon under the Forms group. However, it is possible to use the Chart Wizard, which is launched automatically when you drop a Chart control from the Design Ribbon onto a form or report that is in Design or Layout View mode. Finally, both tables and queries contain storage space for PivotCharts directly within their definition, so you can build PivotCharts directly from these base objects. However, one possible method that might be expected for creating PivotCharts — using VBA code — does not exist.


Get Microsoft® Access® 2010 24-Hour Trainer now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.