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 »

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

Jul 18th, 2017 / Data Visualization
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 »

The Data Visualization Design Process: A Step-by-Step Guide for Beginners

May 1st, 2014 / Data Visualization
Visualizing numbers in charts, graphs, dashboards, and infographics is one of the most powerful strategies for getting your numbers out of your spreadsheets and into real-world conversations. But it can be overwhelming to get started with data visualization. In this step-by-step data visualization guide for beginners, I’ll walk you through the data visualization design process so that you can transform your spreadsheets into stories.
More »