Sparking Interest in Summer Reading

With the official start of summer just a couple of weeks away and students on summer vacation, public libraries are focused on kicking off their summer reading programs! I have fond memories of participating in these programs and competing for fun prizes many years ago, but summer reading doesn’t have to end with childhood. As we will see in the visualizations below, many libraries across Colorado have programs for teens and adults as well! 

In the summer spirit of spending more time in the sunshine and less time staring at a screen, this post will share a few tools in Excel that can help you quickly display data trends without the time consuming process of building fully developed charts and graphs. I began developing content for this post by exploring sparkline options in Excel, but along the way I discovered additional options in Excel, similar to sparklines, which can convey information often just as effectively…

Continue reading this post on and check out more posts on research in a library context from Library Research Service.

LRS’s Colorado Public Library Data Users Group (DUG) mailing list provides instructions on data analysis and visualization, LRS news, and PLAR updates. To receive posts via email, please complete this form.