Automatic axis range calculation should take into account the visibility of the chart series (i.e. the data points of a collapsed series should not be respected). Note: This is by design. The range of all series forms the range of the axis. If the user wants the collapsed series not to affect the range of the axis he can remove them.
We need this ASAP. If this is not to be fixed soon, please advise a work-around method. Thanks