10 Comments

  • Dave E. says:

    I love this simple and effective solution to the dreaded Double Y axis. Hoping to see more posts! Warm regards.

  • […] In my previous post, I demonstrated how to remove double y axes, in which we’ve got total grants awarded (dollars) on the left and the number of projects that were funded (a tally of projects) on the right. […]

  • CaitCat says:

    This is very smart. Too often we try to get it all on one graph, but that’s not the way our minds work. You are so right to point out that we need a beginning, middle, and end.

  • Tony K says:

    You could also consider a scatter plot with the line connection ordered by year…

  • Tony K says:

    No scatter plot looks weird. I think that doing the math to show Dollars per project is the best…

  • Tony K says:

    OK. Never mind. You got that at the end. ADD is a terrible thing to waste. LOL

  • Tom says:

    Really lovely example of clear thought and delivery. The way the solution is presented step by step is subtle but brilliant. Particularly the way additional content is introduced, thereby surpassing the value proposition of the original double axis chart. Nicely done!

  • […] The double y-axis graph is a shortcut that does not present data in a logical way that can elucidate its meaning. This graph shows project funding staying stable, but the number of projects funded decreasing. You can begin to see the trend the data are showing, but it is not made explicit. (Image source: annkemery.com) […]

  • Eve Benen says:

    I’d do a bar chart on the number of projects (or vice versa) which would make it easier to understand which data went with which axis. My 2 cents. But good point on how not everything belongs on the same chart.

  • eric says:

    Great tip! This is a good solution i’ll try to implement.
    Even I get confused when creating these double y-axis charts sometimes .

  • Leave a Reply to Eve Benen Cancel reply

    Your email address will not be published. Required fields are marked *

    Removing the Double Y Axis

    Updated on: Oct 19th, 2016
    Data Visualization
    ,
    Three line charts side by side that give viewers all the information they need and answers any questions they may have.

    My least favorite charts of all time include clustered bar charts, 3D exploding pie charts, and line charts with two y axes. By now, hopefully you know my style. I’m not just going to complain about a graph without offering an alternative.

    Sometimes we need to compare two different variables with two different units, like the total grants awarded by an agency (dollars) compared to the number of different projects that they supported (number of projects).

    Your poor viewer would read the regular axis on the left. They’d probably understand that just fine–Total Grants Awarded. But then they’d have to figure out which line corresponds to that axis. And the separate legend below the graph isn’t helping much because it requires zig-zagging eye movements (no worries–solution here). Their eyes would eventually shift over to the right side of the graph. They’d they’d encounter another y axis.

    Another one? Wait, what? With different units? But I thought this graph was talking about grant dollars? Or is it about the number of projects? This is getting confusing. Okay, it’s not just the viewer confused here. It’s me. Every single time. I used to think these graphs were some kind of sick joke, or at the very least, had some type of virus that accidentally arranged two separate graphs right on top of each other.
    Line chart with double y-axis.
    Unless your viewer looks at graphs with double y axes every day (unlikely–be honest), this is the wrong graph type.

    First things first. Present the first variable, Total Grants Awarded. You viewer can skim the shape of the line and think about the implications of the graph.
    Line graph that presents the first variable, Total Grants Awarded. You viewer can skim the shape of the line and think about the implications of the graph.
    Nudge that graph over to the side:
    Line graph that's nudged over to the side.
    And add the second variable beside it.

    In my remake, I’m presenting the data piecemeal. Think about the order in which you want viewers to make sense of your graph. First, I want viewers to see the variable on the left. Second, I want them to see the variable on the right. Two side by side line charts.
    The beauty of this revision is that I’ve got plenty of space for subtitles. I find interesting nuggets, like the minimum values, maximum values, averages, and totals, and add that background information in the form of a subtitle. I don’t hide the cool stuff in the paragraph above my graph or below my graph. I put the cool stuff in plain sight, right above the graph.
    Two line charts side by side with information about the data above each.
    With my remake, I’ve got plenty of space to add a third variable if needed. First, my graph talks about the dollar amount given out. Then, my graph talks about how many projects were funded. The logical next step is to consider how the average project size has shifted over the years. That’s probably what my viewers would start wondering: If the agency’s total funding has remained pretty constant over the years… but the agency is funding fewer grantees… then, the average project size must be increasing, right? I try to anticipate what my viewers will be curious about and then I place the answers to their questions right alongside the other graphs. Not on the the next page. Not on the next slide. On the same page as the other related information.
    Three line charts side by side that give viewers all the information they need and answers any questions they may have.
    The original graph with the double y axis didn’t let me show the graph in the correct order. I couldn’t show the graph in any order, actually. Both the variables were smushed on top of each other on the same graph. Now, my story has a beginning, middle, and end.

    Bonus

    Download my Excel file and practice adjusting my template with your own numbers.

    Download the Excel File
    More about Ann K. Emery
    Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

    10 Comments

  • Dave E. says:

    I love this simple and effective solution to the dreaded Double Y axis. Hoping to see more posts! Warm regards.

  • […] In my previous post, I demonstrated how to remove double y axes, in which we’ve got total grants awarded (dollars) on the left and the number of projects that were funded (a tally of projects) on the right. […]

  • CaitCat says:

    This is very smart. Too often we try to get it all on one graph, but that’s not the way our minds work. You are so right to point out that we need a beginning, middle, and end.

  • Tony K says:

    You could also consider a scatter plot with the line connection ordered by year…

  • Tony K says:

    No scatter plot looks weird. I think that doing the math to show Dollars per project is the best…

  • Tony K says:

    OK. Never mind. You got that at the end. ADD is a terrible thing to waste. LOL

  • Tom says:

    Really lovely example of clear thought and delivery. The way the solution is presented step by step is subtle but brilliant. Particularly the way additional content is introduced, thereby surpassing the value proposition of the original double axis chart. Nicely done!

  • […] The double y-axis graph is a shortcut that does not present data in a logical way that can elucidate its meaning. This graph shows project funding staying stable, but the number of projects funded decreasing. You can begin to see the trend the data are showing, but it is not made explicit. (Image source: annkemery.com) […]

  • Eve Benen says:

    I’d do a bar chart on the number of projects (or vice versa) which would make it easier to understand which data went with which axis. My 2 cents. But good point on how not everything belongs on the same chart.

  • eric says:

    Great tip! This is a good solution i’ll try to implement.
    Even I get confused when creating these double y-axis charts sometimes .

  • Leave a Reply to Eve Benen Cancel reply

    Your email address will not be published. Required fields are marked *

    You Might Like

    Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

    Enroll

    Inside our flagship dataviz course, you’ll learn software-agnostic skills that can (and should!) be applied to every software program. You’ll customize graphs for your audience, go beyond bar charts, and use accessible colors and text.

    Enroll

    Subscribe

    Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.