8 Comments

    Leave a Reply

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

    Dataviz Challenge #5: How to Make a Diverging Stacked Bar Chart in Excel

    Sep 6th, 2013 / Data Visualization / , , , ,

    I’ve been in love with diverging stacked bar charts since I saw Joe Mako’s submission to Cole Nussbaumer’s dataviz challenge last December. Joe made this contest-winning chart. But in Tableau! The amazing but expensive software!

    Could I ever create one in Excel?!

    Yes! Luckily I’d learned about the Values in Reverse Order feature from Stephanie Evergreen. With Joe’s inspiration and Stephanie’s strategy, I started making these beauties for myself in Excel.

    I wanted to share the chart secrets with all of you, so last month, I challenged readers to re-create a diverging stacked bar chart like this one:
    diverging_before-after

    It looks like I’m not the only one who loves diverging stacked bar charts. Congratulations to the 12 contestants! In order of submission, they are:

     

    Most contestants seized the opportunity to use their own datasets and made adjustments as needed. For example, Sheila’s dataset fit a traditional stacked bar chart better than a diverging stacked bar chart, and Anjie needed to display cut-off scores.

    So how do you make these diverging stacked bar charts, anyways?! There are at least two strategies: Either a) create two separate charts, a strategy demonstrated in previous posts like this one, or b) use floating bars, a strategy demonstrated in previous posts like this one. Stephanie Evergreen blogged about strategy B a few weeks ago and her explanation is pretty awesome, so I’m going to focus on strategy A today.

    Here’s a slideshow about the two-charts-in-one strategy. Enjoy!

    Bonus: Download the Materials

    Download my Excel file.

    Share Your Feedback

    Nearly all of the contestants requested friendly feedback on their graphs. In most cases, contestants were trying these charts for the first time and thinking about whether or not these charts could be adapted for their datasets. What do you think?

    8 Comments

      Leave a Reply

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

      Related Courses

      Most “professional” reports are too long, dense, and jargony. Transform your reports with these practical tips. You’ll never look at reports the same way again.

      Learn More

      Data visualization best practices, practical how-tos, tutorials in multiple software platforms, and guest experts. Designed with busy number-crunchers in mind.

      Learn More

      SPONSORED

      #f-post-el-35{display:none !important}

      #f-post-el-35{display:none !important}

      Learn More