Tableau Butterfly Chart

Tableau Butterfly Chart is the combination of two bar charts on either side of the same y-axis. Typically, Tableau Butterfly Chart helps to compare two data sets at a time. In this article, we use the superstore excel file to build the Tableau Butterfly Chart. 

Creating a Butterfly Chart

Drag and drop the Sub-Category dimension to the row shelf.

Tableau Butterfly Chart 1

Next, drop the Sales measure into the column shelf multiple times. By default, it displays two horizontal bar charts side-by-side.

Tableau Butterfly Chart 2

Right-click on the dimension section to create a calculated field, and select Create Calculated Field.. option from the context menu.

Tableau Butterfly Chart 3

We named the calculated field as Zero and placed 0, which means it shows zeros.

Tableau Butterfly Chart 4

Drag the Zero calculated field onto the columns section in-between the two sales fields. As you see, we have Sales, Zero, Sales, Zero in columns shelf, and Sub-Category in Rows shelf.

Tableau Butterfly Chart 5

Convert the Circles of Zero field to Bars using Marks shelf.

Tableau Butterfly Chart 6

Next, we are converting the remaining column measure fields to bar charts by changing Marks.

Tableau Butterfly Chart 7

Now, you can see the Bar graphs. We have to convert this to Tableau Butterfly Chart.

Tableau Butterfly Chart 8

Let me change the Zero field to Tableau Text or labels.

Tableau Butterfly Chart 9

As its value is Zero, it shows Abc as the text.

Tableau Butterfly Chart 10

Select and right-click on the Sales field, zero fields, and select Synchronize Axis option.

Tableau Butterfly Chart 12

Now the data of both the measures have synchronized.

Tableau Butterfly Chart 13

Right-click on the axis and select the Edit Axis option.

Tableau Butterfly Chart 14

It opens the Edit Axis window to change the range. As you see, by default, the synchronization selects the range automatically. 

Tableau Butterfly Chart 15

Let me change this option to Fixed and change the start value as 0 and end value as 347,101.602227. By this, both the Sales and Zero will be on the same scale.

Tableau Butterfly Chart 16

You can see the Tableau Butterfly Chart.

Tableau Butterfly Chart 17

We have to do the same for the remaining Sales and Zero measures. So, right-click on the Zero measure and click the Dual Axis option.

Tableau Butterfly Chart 18

It almost completes the Tableau Butterfly Chart.

Tableau Butterfly Chart 19

Again, Right-click on the second axis and select the Edit Axis option.

Tableau Butterfly Chart 20

Here, we also changed the range from automatic to fixed, with 0 and 0 as the start and end values. Next, we also check-marked the logarithmic option.

Tableau Butterfly Chart 21

Changing the Marks from bar to text will show the text for the other half of the tableau butterfly chart.

Tableau Butterfly Chart 23

We left it as it is, and you can see the final Tableau Butterfly Chart. 

Tableau Butterfly Chart 24