visualizing data: making numbers come alive
DESCRIPTION
ILEAD Ohio Presentation October 23, 2013 Best practices for charts and tablesTRANSCRIPT
Visualizing Data:Making Numbers Come Alive
Chris TaylorDirector, Upper Arlington Public [email protected]
October 23, 2013 ILEAD Presentation
WHAT TYPE OF CHART TO USE?
Horizontal Bar Charts
Other
Playaways
Magazines
Music CDs
Books on CD
Bluray
DVDs
Books
0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000
UAPL Physical Checkout by Format for September 2013
Vertical Bar Charts
Jan Feb Mar Apr May Jun Jul Aug Sep -
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
UAPL 2013 eResource Checkout by Month
ZinioFreegalOverdrive
Line Charts
1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012$15.00
$16.00
$17.00
$18.00
$19.00
$20.00
$21.00
$22.00
$23.00
Hardcover Children's Books Average Cost
Pie Charts
Chart vs. Table
Print Video Audio Digital
Bexley 135,092 18,143 12,710 96,982
Columbus 1,464,406 73,650 112,566 95,013
Grandview 132,495 13,992 12,244 95,035
Southwest 264,763 21,616 23,398 101,031
Upper Arlington 344,759 59,799 38,188 97,031
Westerville 229,985 36,791 24,984 100,297
Worthington 391,685 28,119 49,276 98,452 Bex
ley
Columbus
Grandvie
w
Southwest
Upper Arlin
gton
West
erville
Worth
ington
0
200,000
400,000
600,000
800,000
1,000,000
1,200,000
1,400,000
1,600,000
PrintVideoAudioSoftwareDigital
Thousands
2012 Collection size by format: Franklin County Libraries
GOOD DESIGN BASICS
Lies, Damned Lies, and Statistics
Axis Start and Number Length
UAPL Circulation by Format and Year
2010 2011 2012 985,000
990,000
995,000
1,000,000
1,005,000
1,010,000
1,015,000
Total Print
2010 2011 2012 900,000
920,000
940,000
960,000
980,000
1,000,000
1,020,000
1,040,000
1,060,000
1,080,000
1,100,000
Total Media
2010 2011 2012 -
5,000
10,000
15,000
20,000
25,000
30,000
35,000
40,000
45,000
Total Virtual
Quite a Different Story
UAPL Circulation by Format and YearIn Thousands
201020112012 -
200,000
400,000
600,000
800,000
1,000,000
1,200,000
Total Print
201020112012 -
200,000
400,000
600,000
800,000
1,000,000
1,200,000
Total Media
201020112012 -
200,000
400,000
600,000
800,000
1,000,000
1,200,000
Total Virtual
Another View
2010 2011 2012 -
200,000
400,000
600,000
800,000
1,000,000
1,200,000
UAPL Circulation by Format and Year
Total Print Total Media Total Virtual
Color, Clutter & Consistency
Academic Libraries Product Mix, 2012-2013
Supplies & Equipment; 2420
ILS/Server Hosting; 11500
eResources; 56544
Workshops; 75Membership; 6300
Small/Medium Public
Supplies & Equipment; 615
eResources; 193999
Workshops; 75Membership; 4500
Large Private
Supplies & Equipment; $30,408
Web & Proxy Hosting; $11,875
ILS/Server Hosting;
$649,708
eResources; $1,163,328
Workshops; $525
Membership; $117,300MARS Authority Control; $585
Small/Medium Private
Mix your indicators for different data
TablesLibrary BEXLEY CML GRANDVIEW SOUTHWEST UAPL WESTERVILLE WORTHINGTON
Total Collection Size 263,113 1,745,635 254,206 410,808 539,777 392,198 567,589
Library BEXLEY CML GRANDVIEW SOUTHWEST UAPL WESTERVILLE WORTHINGTON
Total Collection Size 263,113 1,745,635 254,206 410,808 539,777 392,198 567,589
Library BEXLEY CML GRANDVIEW SOUTHWEST UAPL WESTERVILLE WORTHINGTON
Total Collection Size 263,113 1,745,635 254,206 410,808 539,777 392,198 567,589
BetterLibrary Total Collection Size
BEXLEY 263,113 CML 1,745,635 GRANDVIEW 254,206 SOUTHWEST 410,808 UAPL 539,777 WESTERVILLE 392,198 WORTHINGTON 567,589
Even BetterLibrary Total Collection Size
CML 1,745,635 Worthington 567,589 UAPL 539,777 Southwest 410,808 Westerville 392,198 Bexley 263,113 Grandview 254,206
INFOGRAPHICS
Early Infographic?
Free Infographic Websiteshttp://piktochart.comhttp://www.easel.lyhttp://infogr.am
Resources
• http://www.slideshare.net/MattHunter/how-to-present-data-in-powerpoint
• http://www.garrreynolds.com/preso-tips/design/