Here is my situation,

I have a chart with 5 line series on it, one of the series is normally much larger than the others so I would have the following data

Series 1 1, 5, 10, 5, 0
Series 2 1, 5, 10, 5, 0
Series 3 1, 5, 10, 5, 0
Series 4 1, 5, 10, 5, 0
Series 5 100, 500, 10000, 750, 200

so this chart ends up with a scale on the left axis of 0 -10,000. What I would like to do is when a user clicks on the Legend and hides Series 5 I want the Left Axis to adjust scale so say 0 - 10.

Does anyone have any Ideas on how to accomplish this?