Excel T-shirt
Whenever I’m teaching data visualization in Excel, the main thing I keep reminding people is, when in doubt, right-click. It will usually solve whatever dataviz problem you’re having.
Continue readingSearch Results
Whenever I’m teaching data visualization in Excel, the main thing I keep reminding people is, when in doubt, right-click. It will usually solve whatever dataviz problem you’re having.
Continue readingOne of the encouraging trends in the data visualization space right now is the focus on accessibility. While the data visualization field has for too long focused solely on visual impairments—primarily red-green color vision deficiency or “color blindness”—there is more…
Continue readingThis is the first book available on the market that shows people how to create more advanced data visualizations in the Excel software tool. It provides step-by-step instructions and downloadable Excel files, that readers can use to expand how they…
Continue readingI saw this really nice tile grid map with slope charts from Philip Bump in the Washington Post a few weeks ago. It shows changes in COVID-19 cases (per 1,000 residents) and deaths (per 100,000 residents) at three points during…
Continue readingHave you ever created an Excel chart where the labels stretch out to infinity or are incomplete so you can’t read them? I’ve got a couple of tricks for you, which I’ll lay out here and in this short video…
Continue readingThere are a lot of things to like about this relatively simple bar chart from a New York Times story about reducing gun shootings in the United States: The use of the red color on the first and last bar…
Continue readingI’m a big fan of Stripe Charts–lines or dots that show individual elements in your data, often used to show the distribution. I recently came across this very cool scrollytelling piece from Connor Rothschild on the use of paint colors…
Continue readingA couple of weeks ago I took the morning off from work to go to the mall—the first time in over a year—to visit the Lego store and pick up two new sets: Everyone is Awesome and the Lego World…
Continue readingWritten for the spreadsheet user but also goes beyond basic Excel skills Learn how to extract, clean, and transform data Thorough, modern reference about data and data visualization
Continue readingAs you probably know, Excel does not have a native image-exporting feature, so it requires a separate process to create a high resolution, standalone Excel chart. Many people create standalone graphs by taking screenshots of their Excel window, but screenshots…
Continue reading