Escaping the Bar Chart

Jun 8th, 2021 / Data Visualization
Bar charts aren’t evil. But they’re overused. I talked about Designs to Start Using Instead at the DataScienceGO conference in April 2021. We talked about my three favorite techniques for exploratory data visualization– spark lines, data bars and heat tables– and then I gave them some different options for maps. Are you ready to escape the bar chart?
More »

24 Conditional Formatting Visuals in Microsoft Excel that Should Be Retired

“You should go work at Microsoft and fix Excel’s terrible formatting.” I can’t tell you how many times I’ve heard this from workshop participants. Bill Gates, are you reading this?? Microsoft Excel is lonnnnng overdue for some updates. Don’t get me wrong—it’s still my favorite program. With 750 million users worldwide, I won’t be switching to anything else. It’s used by every business professional I know for at least part of their workflow. I’m getting tired of making excuses for Microsoft. Here are 24 conditional formatting visuals that should be retired ASAP because they’re ableist, time-consuming to read, or look like they’re from 1995.
More »

Re-envisioning a University’s Monthly Report: Two Reports with Two Different Purposes

Oct 20th, 2020 / Dashboards
“How can I show my audience that 24,000 is a big number??” an evaluator asked me. She’s right; this is challenging. A single number on its own doesn’t tell us anything. Have you heard those (un)professional recommendations like, “Just type the 24,000 in large font so it grabs attention!” or “Add an icon next to the 24,000 to bring it to life!” Sigh. Want to bring numbers to life? We need to compare numbers to something. Here are two suggestions.
More »