LibGuides Home: Statistics for Connecticut Public Libraries: Chart & Report Creators

Chart & Report Creators for Your Library

Create Charts in Seconds! Example of Charts

These Do-It-Yourself tools require no knowledge of Excel or Chart-Making. If you can find your library in a list, then you can create customized charts for your library. Copy and paste your charts into any document or presentation, or print or download sets of charts. These statistical measures have been reported in the Annual Report of Public Libraries and can be found in CT Public Libraries: A Statistical Profile.

Excel Chart & Report Creators:

CT Chart & Report Creator, FY2021
Easy to use. Create charts for your library, comparing to others in a population range or with up to 5 other specific libraries that you choose. You can also create charts for your municipality (combining data in multiple-library towns) and compare to other municipalities. Median reports let you compare numbers easily for dozens of measures.
CT Chart & Report Creator, 1996-2021 - Individual Library Trends Over Time [Excel]
See the 12-year or 26-year trends for a specific library, with comparisons to similar wealth and population groups.
What towns are in our group?
Sort this spreadsheet to see what other libraries are in your comparison groups based on population and AENGLC wealth rankings. FY2021

National Public Library Chart and Report Creators

National Public Library Chart & Report Creator [Excel]

The Excel file (3.95 MB) available above:

Was originally made for Connecticut public libraries but may be used by any public library in the United States.
Creates charts that compare your library to libraries in your state and the nation, including just those that have a similar population.
Requires absolutely no knowledge of Excel.
Uses the latest data (2020) available from the Public Library Survey released by the Institute of Museum and Library Services in July 2022.
May take some time to download.
Will be updated with the next year's data as soon as it becomes available.

National Public Library Data [Tableau web-based resource]
The same data as is found in the Excel file above, but with Tableau's additional data visualization capabilities.
Library Search and Compare tool from IMLS
This online tool from IMLS uses data from their FY2019 Public Libraries Survey. You can compare your library with others across the country based on number of branches, circulation, revenue, staff, service population, visits, and programs.

Chart-Makers from Past Years [Excel]

Contact Information

State Data Coordinator

Maria Bernier
Division of Library Development, Connecticut State Library
786 South Main St.
Middletown, CT 06457
860-704-2204
maria.bernier@ct.gov