Using automatic range will prevent you from changing your range. You can only do this when using a RangeType = Custom and setting RangeMin and RangeMax.