A Primer for Creating Diverging Stacked Bar Charts

By Dave Paradi

When I first heard the name of this visual, diverging stacked bar chart, it seemed complex. As I learned more about it, I realized how valuable it is to know about this type of visual in business presentations.

Let’s start with an example of such a visual:

Issue 310 visualsA diverging stacked bar chart is a bar chart that can have one or more segments on each side of a dividing line. The dividing line separates the two groups or categories of data. The above example has only one segment on each side of the dividing line (which is not explicitly shown) and the two groups of data are hardware sales (HW) and software sales (SW).

The reason that this type of graph works well is that it allows the viewer to easily compare the relative size of each group of related data. Each group starts at the dividing line and moves either right or left. In the above example, it is easy to see that in each year software sales are much larger than hardware sales.

Here is another example. In this case, there are multiple segments on each side of the dividing line. The dividing line here represents the goal for customer service ratings (8 out of a possible perfect score of 10). To the left of the line are the ratings below the goal and to the right of the line are the ratings above the goal. The more the overall bar is to the right, the more that call center has ratings above the goal.


It is easy for the audience to see how much of the bar is to the right of the dividing line, indicating performance above the goal. Because we wanted to also see the breakdown of scores on each side of the goal, the data is broken down into segments based on the score given by the customer (5 or lower, 6-7, 8-9, and 10). There are more good examples in this article by Darkhorse Analytics.

It seems like this would be a complicated graph to create, but it is actually much easier due to an online calculator I created. You can use the Diverging Stacked Bar Chart Calculator to calculate the values you enter into the data table for a regular stacked bar chart in Excel or PowerPoint. The values to the left of the dividing line are negative and the calculator organizes them so that they appear correctly. The calculator page has additional ideas on formatting the chart and adding text labels to create the type of charts you see above.

When you want to communicate the values of two groups of data that are related, consider whether a diverging stacked bar chart would work for you.

About the Author:

Dave Paradi runs the Think Outside the Slide website, is a consultant on high-stakes presentations, the author of seven books and a PowerPoint Most Valuable Professional (MVP.) For more information, visit www.thinkoutsidetheslide.com

Pin It on Pinterest