How to adjust axis scale when a series is hidden
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?