3 Replies Latest reply on Oct 30, 2018 10:58 AM by Simon Runc

Waterfall Chart - Forcing Y axis not to start with Zero ???

Hi Tableau Lover,

I need help with respect to handling Y axis in Waterfall Chart.

Here is the issue. I have below chart. This is simple plain waterfall chart. However, it's very difficult to see variable from A to J. We cannot tell the difference between A and B.

Reason - Y axis is starting from Zero

Expected Output : - In below example, I have manually edited start point of axis. Now, we can clearly see the difference between A and B. It's visually appealing. I wanted to handle it dynamically. Is there any way/ability to auto-set a minimum based starting point. (Y axis “minimum” for example, 80% of lowest “base” data) ?

Regards,

Sumeer

• 1. Re: Waterfall Chart - Forcing Y axis not to start with Zero ???

hi Sumeet,

So I think this should do the trick

First I create the 80% of Total Value

[Dol +/- YA - LoD Total]

{SUM([Dol +/- YA])}*0.8

which is the Grand Total Column *0.8 (you can change the 0.8, 80%, if you want more or less axis).

I then use this for the Size field

[Size - SR]

IF FIRST()= 0 THEN (SUM([Dol +/- YA])-SUM([Dol +/- YA - LoD Total]))*-1

ELSE SUM([Dol +/- YA])*-1

END

The FIRST() just picks up if it's the first bar or the Grand Total and applied out 80% to the Gantt size, so it's only drawn down to that level. I then change the Axis to not include zero.

Hope that helps and makes sense

• 2. Re: Waterfall Chart - Forcing Y axis not to start with Zero ???

Hi Simon,

Thank you so much for solution.

Unfortunately, I am not able to open this workbook. Could you please send me version with 10.5.3 version ?

Regards,

Sumeet

• 3. Re: Waterfall Chart - Forcing Y axis not to start with Zero ???

No probs, here you go.