Example datasets for 2 articles on Excel PivotTables and PivotCharts. Note that some dataset workbooks may have multiple worksheets that can be examined. All data is in Excel 2010.

References are to figures in these 2 companion articles:

Article 1: Introduction to Using Excel Pivot Tables and Pivot Charts to Increase Efficiency in Library Data Analysis and Illustration.

Article 2: Application of Excel Pivot Tables and Pivot Charts for Efficient Library Data Analysis and Illustration.

Dataset1 from Article 1 - Figure 1, formatted as a regular table.

Dataset2 showing the pivot chart in Article 1 - Figure 2, along with its filtered pivot table and source data.

Dataset3 showing the pivot chart in Article 1 - Figure 3 and Article 2 – Figure 6, along with its unfiltered pivot table and source data.

Dataset4 showing the pivot tables in Article 1 - Figures 4 and 5 with instructions for creating Article 1 - Figure 6. It would also illustrate Article 2 – Figure 5 if the filters on worksheet “Figs. 5 & 6 by year” were removed.

Andrea Miller

Duane G. Meyer Library

Missouri State University

901 S. National Ave.

Springfield, MO 65809

Page last updated on Nov. 13, 2013