7 Replies Latest reply on Aug 14, 2018 7:56 AM by Shinichiro Murakami

# Aligning axes

Hello all,

I have been strugling with a chart in which I have two axes (vertical axes). One includes numbers (-1 to +1 for instance) while the other one includes % (-150% to +150% for instance). When I click on synchronise axes Tableau automatically crosses at 0 and 0%. Does anyone know how I can tell Tableau to cross at 0 (for left axis) and 100% (for right axis)? Thanks a lot

• ###### 1. Re: Aligning axes

I would create an offset calculation to use for this (x-1).  Use this for your dual axis rows calc, then hide the axis and use the original measure for the label or tool-tip.

1 of 1 people found this helpful
• ###### 2. Re: Aligning axes

Hi Ana,

This is because when you are synchronizing the axis in Tableau,it brings both the axis on the same level.

In your case ,it's just converting the number on primary axis to % on secondary axis.

• ###### 3. Re: Aligning axes

Hi! Thank you very much for your quick reply. I am not sure I made myself clear. Numbers in left axis do not correspond exactly to number on the righ axis. Besides min and max of the axis might change with time. I just want the left vertical axis to cross the horizontal axis at 0 and the right vertical axis to cross the horizontal axis at 100% . Any other ideas?

• ###### 4. Re: Aligning axes

Again attached is my solution in 10.1 workbook.

• ###### 5. Re: Aligning axes

HI Ana

Assuming line height is around 0.8~1.2 and Bar height is around -0.6 ~ 0.2.

Final Image

The concept is not aligning "Zero" but align whole range with min and max to align 1 and 0.

Thanks,

Shin

• ###### 6. Re: Aligning axes

Thanks a lot Sin! Your explanation is super clear and it works

Thanks again, i really appreciate you help

• ###### 7. Re: Aligning axes

HI Ana,

You are welcome, and