How to Show Problems and Solutions in One Chart

Data Tips.png

Data visualizations are kind of like beards or kale. They used to be decidedly uncool, but are now hip, at least in certain circles. Yet, even with the rising popularity of charts, maps, and graphs, I think many of us have a faint feeling of aversion when encountering them. For one, they may be hard to decipher. But there’s another problem too. They often are the bearers of bad news. They show us how widespread a problem is or how it’s increasing. Worse, they rarely give us any hope of improvement.

Wouldn’t charts, maps, and graphs be more engaging and helpful if they showed both problems AND solutions? Let’s talk about how to get that done.

Show Two Scenarios

Show the difference between how things play out with and without an intervention or program. The now-famous flatten the curve graph (shown below) did this without any real data. The point was just to show how the number of cases would likely differ with and without public health measures to slow the spread of COVID.

Source: C.T. Bergstrom

Here’s a graph that shows two scenarios with real data. The data point labels are particularly helpful in this example. By comparing two different cities, the graph suggests that a delay in the start of social distancing interventions may have a huge effect on the severity of an outbreak.

Show A Change In The Trend

Another way to present a problem along with a solution is to show how a trend alters following an intervention. This graph shows projected data for several types of interventions: the current policy, alternative policies, and the absence of policies. In the absence of policies, global warming is expected to reach 4.1°C – 4.8°C above pre-industrial levels by the end of the century. Current policies are projected to result in about a 3.0° rise over pre-industrial levels. Other pledges and targets that governments have made would limit warming to even lower amounts.

This one effectively uses bubble size and color to show a trend alteration following the introduction of the measles vaccine.

Source: Sciencemag.org

On the uncool-to-very-cool spectrum, data visualizations that show both problems and solutions are very cool. To see what other things are cool/uncool check out CoolnessGraphed.com.

To see past data tips, including those about other chart types, click HERE.


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.