Vertical value axis

[jamie_lo75]

I need help, I have a customized chart.. Is there a way to automate the vertical value axis ?
Everytime I change the first value in O to C (ex. 50 to 45), the total minutes is not changing in the vertical axis value and I need to change manually

 

[RoryA]

It looks like the axis values have been manually set already as there is a Reset button, rather than Auto. That will prevent them from changing automatically.

 

[jamie_lo75]

It looks like the axis values have been manually set already as there is a Reset button, rather than Auto. That will prevent them from changing automatically.

thank you, i've already tried that but it still does not work. I need it to change automatically not to prevent them from changing automatically

 

[RoryA]

If they are all set to auto, it will change automatically, but based on an algorithm, which means that it may not necessarily alter for every single change in value - eg if your total goes from 140 to 141, it's unlikely that the axis bounds will change. Looking at your images, I suspect you would be better off using a 100% stacked column chart so that it always occupies the entire axis in total, but that's a guess as you haven't really provided any context.