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 Tell a Story with Data: Titles, Subtitles, Annotations, Dark/Light Contrast, and Selective Labeling

Feb 24th, 2016 / Data Visualization
Do your viewers want to see the data presented as-is (the traditional approach to data visualization)? Or, do they want you to cut to the chase and interpret the data (the storytelling approach to data visualization)? In this article, you’ll learn how titles, subtitles, annotations, dark/light contrast, and selective labeling can help you tell a story with data.
More »

Matching Graph Colors to Branding

Feb 9th, 2016 / Data Visualization
Color is about much, much more than simply making your graphs look pretty. Adding color to graphs is simultaneously the easiest and absolute hardest technique to nail. When used well, color can enhance branding when you match your publication’s color palette to your brand and logo. I’ll walk you through the steps.
More »

How to Make a Heat Table in Microsoft Excel

Apr 14th, 2015 / Data Visualization
Just because I adore graphs doesn’t mean that I shun tables. I insert the occasional table inside the body of my report. When creating traditional tables, I follow the Dark Horse Analytics guide. When I’m presenting tables in a presentation, webinar, or full-color report, I create heat tables. Today I’m covering how to make a heat table in Microsoft Excel.
More »