In this post we will see how to make diverging bar chart in Tableau. Additionaly, it will be also shown how to manipulate with number formats.

Lets start with the connection to the Sample-Superstore.

In order to not have too much data, we will make the report just for randomly chosen State, e.g. Washington. Putting State in Filters panel and choosing Washington, double clicking Profit and Sales, and then choosing horizontal bars in Show Me, we will have this preview:

Since we want to have diverging bar chart, 1st step is that we make one of the measures negative. To have that, we just have to make calculated field:

Putting this new calculated field -Sales and Profit into the Columns, Order Date in Rows and showing all mark labels, we will get our first diverging bar chart :)