I am creating a bar chart with values ranging from 100 to 100,000. I keep the X axis as auto scaling allowing me to change the starting point.

From what I understand, if two bars variance is greater than 1/6 (16.6%) the graph will start from 0, and if the difference is less than 1/6 (16.6%) the graph will auto scale.

I want to auto scale irrespective of whether the variance is greater than 16.6% or not. How can I do this?