Automatically Updating Graphs in Word or PowerPoint

I have so much money in the bank I’m going to give away my number one reporting time saving secret (HAHAHAHAH not at all! I’m giving it away because I love you and I want to make your life easier). This is how you link Excel to your other reporting…

Read More

The Problem with Dashboards (And A Solution)

Folks, I’ve been discussing dashboards forever. I’ve consulted with dozens and dozens of clients on dashboards. And through all of that experience, I’ve discovered that dashboards kind of suck. Don’t get me wrong, I understand the need for a succinct complication of performance on key indicators. It sure beats a…

Read More

How Dataviz Can Unintentionally Perpetuate Inequality Part 2

Last time Vidhya and I posted on this topic, we addressed how the use of color to visualize individuals can do more harm than good. This time Vidhya joins me again to talk about poverty and opportunity. Organizations in the Minneapolis-St. Paul metropolitan area community identified and started tracking indicators…

Read More

The Difference Between Sloppy and Pro

This is the hardest part of design to get right. It’s what differentiates sloppy, weak design from that which looks tight. It’s the use of a grid. Arrangement matters. It’s the sort of thing that gets talked about in design workshops, but people tend to get so caught up by…

Read More

Guest Post: Best Practices for Control, Run, and Pareto Charts

Nicole contacted me with an email subject line: Thank you for the Data Viz Checklist! and she said she’d been using the checklist to overhaul some of her organization’s data visualizations. I’ve invited her here to showcase her before and afters. I’m Nicole Huggett and I recently transitioned…

Read More

Make A Lollipop Graph in Excel

The simplest way to show many types of data is through a column or bar chart, ordered greatest to least. These will work just fine, most of the time. When do they fall short? Well, when the values are all high, such as in the 80-90% range (out of 100%). Then…

Read More

State of the Union 2016 Slideshow

Dudes, the State of the Union is my Superbowl. I look forward to this event like some people anticipate the Oscars. This is my deal. Why? Because the enhanced version of the SOTU features a data-based slideshow, a perfect study in how graphics can help underscore a point. And, as…

Read More

Data Viz Challenge Redesigns!

Last week I launched a challenge to redesign financial info from the Gates Foundation annual report. I was looking for entries that made the data more engaging than a table, matched the level of design of the rest of an annual report, and still reported each element originally presented…

Read More

Data Viz Challenge: Gates Annual Report Financials Page

So! This was fun. Yesterday I published a post where I pleaded with nonprofits and foundations to add viz to the financials page of their annual report, which is usually just presented as a table of numbers. I shared two redesigns that I made. The one I remade for…

Read More

Data Visualization for Non-Profit & Foundation Annual Reports

Annual reports are where non-profits and foundations pull out their designer big guns. This is where they show off their muscles, like studs on the beach. The annual report is the place where an organization oils its accomplishments til they shine. The annual report is so important, most organizations still…

Read More