Document Type

Article

Publication Date

2014

Keywords

Excel® PivotTables, Excel® PivotCharts, pivot tables, pivot charts, library data analysis, library data 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.

Comments

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.

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.

DOI for the article

10.1080/01930826.2014.915162

Department

Libraries

Share

COinS