I've set the scale to Max 1000 which is fine most of the time but very
occasionally there will be a value of more than 1000 and for these instances
I need the scale to automatically rescale.

Is it possible to set the Y scale of a graph to Max 1000 but if the data
exceeds 1000 then revert the scale to Auto? If so, how do I do this?

Many thanks