Beyond the Bar: Alternative Methods for Visualizing Two Points of Change

image showing three alternatives to visualizing change between two time points: 1) dumbbell plot; 2) slope graph; and 3) icon.

* This article originally appeared in Nightingale, the Data Visualization Society's Journal *

People love comparisons, whether between two groups or the difference in an outcome between two-time points. Many data (visualization) designers use a clustered bar (or column) chart to visualize two points of change. BUT there are so many options out there!

So, I am dedicating this article to some of my favorite ways to visualize change between two-time points that go beyond the clustered bar chart.

Before diving into the new, we are going to take a walk down data design memory lane.

But first, let's set the scene.

THE DATA

For this post, I generated education data for a fictitious school district. This school district has four schools. The superintendent asked the lead data analyst for the school district to produce a display showing the change in the percentage of students across the four schools who were proficient in math between 2018 and 2019:

data table with four rows showing mathematics proficiency data for four schools between 2018 and 2019.

BAR CHART BASICS

After a first pass of the data, the analyst produced a regular old clustered (horizontal) bar chart:

Clustered Horizontal Bar Chart

The (horizontal) clustered bar chart is a tried-and-true design choice. These charts display data categories on the vertical axis, while values are plotted (in horizontal bars) on the horizontal axis.

A clustered bar chart emphasizes differences in a variable by visually grouping related items. When visualizing change using this chart type, some choose to display the newest time point bar above the oldest time point bar.

Sure, it's simple…and a little boring. I would even go as far as to argue that it is a bit confusing to interpret, no matter which order you place the bars in or how you choose to label the data points. So, back to the drawing board.

After another look at the original design, the analyst thought rotating the chart might spruce things up.

clustered horizontal bar chart showing math proficiency data for four schools between 2018 and 2019. School 1: increased from 45% to 63%; School 2: increased from 55% to 67%; School 3: increased from 64% to 75%; and School 4: increased from 72% to 82

 Clustered Column Chart

The clustered column chart is another conventional visualization. These charts display data as a series of grouped vertical bars across the horizontal axis, with values plotted on the vertical axis. But like the clustered bar chart, clustered column charts are not particularly creative and can become cluttered and confusing when many categories are shown.

clustered column bar chart showing math proficiency data for four schools between 2018 and 2019. School 1: increased from 45% to 63%; School 2: increased from 55% to 67%; School 3: increased from 64% to 75%; and School 4: increased from 72% to 82

Now that we have gotten those commemorative charts out of the way let's look at alternative chart types for visualizing change.

ALTERNATIVE DESIGNS

This is the part of the story when the analyst consults a data designer, and they graciously share their knowledge. And trust me, they are EAGER to expand the analyst's chart repertoire.

First on their list: the dumbbell plot.

Dumbbell Plot

A (horizontal) dumbbell plot is a visualization that shows the differences between two points. Here, the focus is on the distance between the points. Values are displayed across the horizontal axis, while data categories are shown along the vertical axis. Dumbbell plots are a fantastic choice as their straightforward design minimizes visual clutter making them easy to read and understand.

dumbbell plot showing math proficiency data for four schools between 2018 and 2019. School 1: increased from 45% to 63%; School 2: increased from 55% to 67%; School 3: increased from 64% to 75%; and School 4: increased from 72% to 82%

Another option shared by the designer is the slope graph.

  

Slope Graph

Slope graphs are a line chart showing (the magnitude and direction of) change between two points for multiple categories. When using this graph, the steepness of the slope of the lines connecting the two points is of interest; a steeper (or flatter) slope indicates a larger (smaller) change.

slope graph showing math proficiency data for four schools between 2018 and 2019. School 1: increased from 45% to 63%; School 2: increased from 55% to 67%; School 3: increased from 64% to 75%; and School 4: increased from 72% to 82%

Since the designer was not sure how many schools would be included in the display, they also taught the analyst about the 'small multiples' approach.

 

Slope Graph Small Multiples

A small multiple is a series of similar graphs or charts arranged in a grid layout. Each chart in a small multiples series shares the same axes, scales, size, and shape. Using the small multiples approach, each school in the original display has its own chart.

slope graph, small multiples layout of  math proficient data for four schools between 2018 and 2019. School 1: increased from 45% to 63%; School 2: increased from 55% to 67%; School 3: increased from 64% to 75%; and School 4: increased from 72% to 82

This technique is preferred by designers when a chart has many categories. The uniform design and the increased white space simplify interpretation and allow easy comparisons across categories.

A final choice is an icon

 

Icons

Icons are graphical symbols that communicate a concept. For example, an upward arrow or triangle pointing upwards could indicate 'increasing.'

Okay. Okay. Icons are not a chart type per se. BUT icons are a powerful way to communicate information, AND they can easily be incorporated into a variety of formats, including reports, dashboards, and stand-alone tables.

When visualizing change, I love to embed icons within a larger data table. Why? It's an easy way to appeal to folks who need to see the numbers but also people who want to know whether something changed (and whether the change is positive or negative).

data table with icons showing math proficiency data for four schools between 2018 and 2019. Column 1: school names; Columns 2 and 3: percentages for 2018 and 2019, respectively. And Column 4: an arrow icon indicating whether scores increased

--

Now, I want to go on record and say that bar charts ARE NOT BORING. I get A LOT of use out of bar charts.

But you know what is boring? A report, slide deck, or dashboard that ONLY includes bar charts.

There are so many visualization techniques at your disposal for displaying change over two-time points. Depending on your goal and audience, one option may be more effective than another.  

So, don't limit yourself. Venture beyond the clustered bar chart.

Previous
Previous

Gridlines Be Gone!

Next
Next

Apply a Process to Multiple Data Sets