VizWiz

Launch, grow, and unlock your career in data

October 19, 2016

Tableau Tip Tuesday: How to Create a Diverging Bar Chart with One Measure

, , , , , , 4 comments
This week's tip came about via a question from Bethany Fox of the Data School during our client project. I had previously posted a tip about how to create a diverging bar chart with two measures, but she wanted to create a diverging bar chart based on only one measure.

With a cheeky use of the INDEX table calculation, this was quite straightforward. In the video below, you'll see that the middle of the charts aren't lined up. I fixed this by using the INDEX calc again. You can download the workbook to see how I got it to work.

4 comments :

  1. UnknownMarch 4, 2017 at 2:05 PM

    Hello, Andy.

    I'm trying to use your tutorial as an exercise about how to make these divergent charts. So I downloaded your workbook and I have seen that you included again "Sales" in the columns, now with INDEX()=2, what centralizes the 0 point.

    I tried to reconstruct your chart, but in the end what I got was a chart with a centralized 0 point, but overlapping values. Do you have any idea about how to solve this problem? Thanks in advance.

    ReplyDelete
    Replies
    1. VizWizMarch 6, 2017 at 10:25 AM

      The trick you're missing is that I made the secondary axis (INDEX()=2) a negative. This makes the axis go the opposite direction instead of overlapping. Then you format the value so that it displays as positive.

      Delete
    2. UnknownMarch 10, 2017 at 3:20 PM

      Thanks a lot, Andy. Gave me some light. :)

      Delete
  2. matrix7116May 3, 2017 at 9:25 PM

    Thank so much Andy.

    ReplyDelete

Subscribe to: Post Comments ( Atom )