Application of Excel® Pivot Tables and Pivot Charts for Efficient Library Data Analysis and Illustration
Exce® pivot tables and pivot charts are ideal tools for increasing efficiency in previously time-consuming tasks involved in the analysis of library data, such as electronic resource usage statistics. Building upon the background presented in an introductory article, this companion article continues with information concerning essential techniques and applications. Data must be properly formatted in preparation for its use with pivot tables and pivot charts. Steps in the creation of both pivot tables and pivot charts are detailed along with potential pitfalls. Best practices are covered with specific tips for ensuring accurate results.
This is an electronic postprint version of an article published in Journal of Library Administration 54, no. 3 (2014): 169-186. Journal of Library Administration is available online at: http://www.tandfonline.com/doi/abs/10.1080/01930826.2014.915162.
Excel® PivotTables, Excel® PivotCharts, pivot tables, pivot charts, library data analysis, library data illustration
Miller, Andrea. "Application of Excel® Pivot Tables and Pivot Charts for Efficient Library Data Analysis and Illustration." Journal of Library Administration 54, no. 3 (2014): 169-186.
Journal of Library Administration