Tableau is already dynamic in terms of axis . You fixing the axis is what is causing this issue.
Can you please recheck the functionality.
I think you didn't get my point. Please look sheet 5 and sheet 6(added now). The actual scenario is like in sheet 5 and I wanted to have India in the visualization and focus more on Afghanistan and Cameroon. So, I fixed the axis at 90%. After fixing the chart enlarges. See the difference in bar sizes in both sheets. Labels are also visible.
But, now look sheet number 7, 2012 data. That means, suppose in some rare cases if India % comes below 90%, it will not be shown in the chart. So, in such cases the user should have the choice in the dashboard to decrease the axis to say 80% then India can be visible. I'm asking for this flexibility to decrease or increase the axis in the dashboard when required.
I think you can understand the scenario now.
axis hide.twbx 6.7 MB
Unfortunately I cannot open your workbook, but have you looked at create reference lines but making them hidden?