How to Transform a Table of Data into a Chart: Four Charts with Four Different Stories

A few weeks ago I gave the keynote speech at the Alabama Power Foundation’s Elevate conference for several hundred of their grantees and partners. What a day! As part of the most-practical-keynote-you’ve-ever-heard emphasis, we included makeovers from the grantees’ real projects. In case it’s useful for my blog readers, I’m sharing one of those makeovers with you today.
More »

How to Visualize Pre/Post Survey Results in Microsoft Excel

Does your organization collect data through online surveys or paper surveys? Do you need an easy, effective way to visualize survey results in Microsoft Excel? Surveys are one of the most common ways to collect information. In this blog post, we’ll depict how participants’ knowledge changed after participating in an educational program at a museum. Bonus: You can even download the Microsoft Excel spreadsheet and the Microsoft Word document that I used to create these data visualization makeovers.
More »