How to Make a Diverging Bar Chart in Tableau

The trick to the first approach is to simply make a bar chart for each side of the diverging bar chart and reverse the axis scale for one of the charts so the bars point left or down (based on whether your measure is on the Rows Shelf or Columns Shelf). In this example, the right side of the chart is the primary view and the left side is a second view with the axis reversed and the year numbers hidden (because they are already represented in the first chart). You can hide the header by right-clicking on the header for the second sheet and deselecting “Show Header”. I then lined up the two sheets on a dashboard.

To reverse an axis, right-click on the axis and choose “Edit Axis…”. This will open a dialog box where you can choose to reverse the scale.

Making a diverging bar chart on a single sheet

It’s often best practice to consolidate sheets when possible which will give you a slight bump in efficiency but also make your workbook easier to manage. For this second approach, we will create a new diverging bar chart using a calculated field. To start, I’ll make a stacked bar chart showing wins per conference per season.

The trick to creating a diverging bar chart on a single sheet is to create a calculated field that multiplies the values for some of the dimension members by negative one. Here’s how my calculated field looks to make the values for the AFC go to the left.

Note I’m only using two dimension members in this example so I’m only making one go left, but you could make the marks go left for as many dimension members as you want through the use of OR statements. For example, if I was using the Sample – Superstore dataset to make the Sales values for the East and Central dimension members of the Region dimension go left, my calculated field would be:

IF [Region] = “East” OR [Region] = “Central” THEN –[Sales]
ELSE [Sales]
END

After replacing the original Wins measure with my newly created Diverging Wins calculated field, my chart looks like this:

One word of caution with this chart type which I hope you find obvious; the left side of this chart implies the values are negative. If you are creating a diverging bar chart with positive values on both sides, I encourage you to at least hide the axis and consider adding the positive values to the Label Marks Card.

As you can see, one drawback with consolidating both sides of the diverging bar chart into a single sheet is that the years are listed down the left side instead of the center. There is a hack to improve this that involves a calculated field I often set up called “Placeholder”. The entire formula is MIN(0).

Once you have the placeholder calculated field, place it on the same shelf as your existing measure.

Turn the chart into a dual-axis chart by clicking on the Placeholder pill and choosing “Dual Axis”.

By default, this changes my mark type to Circle, but we’ll discuss that in a moment. The most important thing to get the Placeholder measure to line up in the center is to synchronize the axes. You can accomplish this by right-clicking on either axis and choosing “Synchronize Axis”.

What’s important about this is now that there are two measures on the Columns Shelf, they each get their own set of Marks Cards that can be edited independently of each other.

This means that I can change the color and mark type of the bars back to the way they were and change the mark type for the Placeholder measure to Text. Here’s how my final view looks after making these changes, hiding all of the headers, and adding the Season (Year) dimension to the Text Marks Card for the Placeholder measure.

Again, this is just one example for illustration purposes, but there are several possible applications for the second axis. One common alternative is to create a dual-axis combination chart like we’ve done, but change the mark type for the second axis to Circle and add an informative label. In my case, I could have used the circle to display which conference won that season and/or by how much. You also do not have to lock the primary or secondary axes at zero; unlocking even more possibilities.

Thanks for reading,
– Ryan