Innovative Tableau

Chapter 37. How to Make a Dual-Axis Waterfall Chart

In this tutorial, we use my 2½ Minutes to Midnight visualization to create a waterfall chart in Tableau. A waterfall chart shows the progression toward a cumulative result by showing how positive or negative values contribute to the total. In my data visualization, the waterfall chart was an effective choice for showing how we’ve moved closer to and further from midnight on the Doomsday Clock since its inception in 1947. We eventually end up at—you guessed it—2½ minutes to midnight. In a corporate environment, waterfall charts can be a great choice for showing how specific segments are contributing to your end goals and/or the makeup of the result.

In addition to the foundational waterfall chart, I’ll show you how to use a dual axis to add value to this type of data visualization. In my example, the dual axis is used to display the absolute number of minutes to midnight after each change. In a corporate setting, we can use the second axis to show absolute changes, percent changes, or some other metric of choice. I also like that the dual axis creates a kind of teardrop effect that helps communicate the direction of the change.

How to Use Running Total to Create a Waterfall Chart in Tableau

Before we begin, let’s look at how the final visual will look:

The data used to create this waterfall chart is quite simple, consisting ...