Title
Application of Excel® Pivot Tables and Pivot Charts for Efficient Library Data Analysis and Illustration
Abstract
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.
Department(s)
MSU Libraries
Document Type
Article
DOI
https://doi.org/10.1080/01930826.2014.915162
Rights Information
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.
Keywords
Excel® PivotTables, Excel® PivotCharts, pivot tables, pivot charts, library data analysis, library data illustration
Publication Date
2014
Recommended Citation
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 Title
Journal of Library Administration
Additional Information
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.