How to Visualize Pre/Post Survey Results in Microsoft Excel

May 9th, 2017 / Data Visualization, Reports
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 »

How to Sort Your Bar Charts

Mar 14th, 2017 / Data Visualization
“Ann, my bar chart is upside down! Help!” A largest to smallest sorting should produce a largest to smallest chart, right? Right? Right? But the chart does a somersault! I’ve never figured out why spreadsheets do this but you have two options to fix it.
More »