Graph Makeover: Dealing with Crossing Lines in Line Graph

I just learned about #MakeoverMonday, an informal challenge and fun weekly event run by Andy Kriebel and Andy Cotgreave, where people do a graph makeover. This week, they asked, how can we improve this graph (raw data here)? As an educational opportunity, here’s how I approach it.

Hotel Revenue vs Travel Agents

1.Crossing lines

First, we have to be careful about letting lines cross on a dual-axis line graph. Research finds it’s more difficult to understand line graphs when the lines cross over.

The other problem is that when lines cross, it sends an unintended message that something has shifted. Something that used to be larger is now smaller. That’s not what we’re saying, and yet there is that subtle message out there. And in fact, there is no reason the lines have to cross. Think about it. They are only crossing because of the arbitrary choice of scales. We can change the crossover point by changing the scale.

 

Slide3

So, generally avoid having lines that criss-cross like this. Instead, change the scale so the lines never criss-cross, or use a combination bar/line graph, or use two different graphs.

Slide4

2. Graph title

Whatever point you are trying to make, write it out as the graph title. Right now, the graph title tells you what data is being measured, but not what conclusions you should draw. When you leave the point unstated, people may not get it, or may get the wrong idea. So spell it out clearly.

Slide5

3. Cause and Effect

I’m going to use two different graphs. Which one comes first? If you are making a cause-effect statement, as we are, put the cause first and the effect second.

Slide6

4. Graph choice

Now, I could use a line graph because nothing says TREND like a line graph. But I’m actually going to use a bar chart instead. Because I want you to get a sense of something DWINDLING down to nothing so I want there to be substance in the graph.

Slide75. Color

With bar graphs, use a soft color for the bars. When you use a dark color, it looks like zebra stripes and creates a moire effect, which is uncomfortable on the eyes. I’m also going to use a positive color for the growth of the online hotel booking revenues and a more negative color for the decline of the travel agents population.

Slide8

6. Pictures

No matter how hard you try, graphs will lack a lot of emotional impact. That’s because they are abstract, and appealing to people emotionally requires something more concrete. Pictures is the missing ingredient.

In particular, pictures of people give you the most emotional impact. And whenever I create a graph I want to ask myself “Are we talking about people right now?” Because if we’re talking about people, and the impact on people, I want to add pictures of those people.

In this case, we’re talking about the decline of travel agents (people!). We’re also talking about rising online hotel bookings. But hotel bookings don’t rise by themselves. They rise because someone is doing something (more people!). So I’m going to reflect that through pictures.

Slide9

7. Contrast

One last thing. Storytelling is about contrast. Good versus evil. Life versus death. Loneliness versus love. So if there’s contrast in the story we’re telling, we want to emphasize that. We’ve done that through the use of color (positive green versus negative red) and choice of pictures (happy older couple versus unhappy younger male). I’m going to punctuate that point with arrows (up versus down).

One blog visitor, Sheila B Robinson, pointed out in the comments section another reason for the arrows: some audience members are color-blind and cannot see certain shades of green and red. The arrows are another cue.

Another blog visitor, Andy Cotgreave who helps run #MakeoverMonday, also posted a helpful comment that the arrows I originally used are too large (see original here). I agree. I like adding annotations to graphs, like arrows, because they quickly summarize data. But the rule is to make them only as large as they need to be, and no more. And I agree the original arrows were like throwing one too many persons into the lifeboat, so here’s my revised final with smaller arrows. (I’ve also used one of my favorite techniques for titles: using ellipses to join two different graph titles into a coherent story.)

CrossingLines Final

Storytelling with graphs is not about accurately visualizing the data. It’s about determining the story in the graphs and then intelligently using design principles to bring that story into our minds and straight through to our hearts. If you want all my techniques for creating clearer, more engaging and more persuasive graphs, look for my new book “Storytelling with Graphs” which I’m hoping to release this year.

Storytelling with Graphs cover

About the author: Bruce Gabrielle is author of Speaking PowerPoint: the New Language of Business, showing a 12-step method for creating clearer and more persuasive PowerPoint slides for boardroom presentations. Subscribe to this blog or join my LinkedIn group to get new posts sent to your inbox.