Adding a new Vertical Axis to a zoomed in plot

Aaron Peronto · Post by **Aaron Peronto** » Tue May 01, 2007 5:21 pm

Start with a plot with just 1 series added to the LEFT vertical axis.
Zoom in on some part of that chart.
Now add a series on the RIGHT vertical axis.

The newly visible RIGHT vertical axis shows data labels of all 0s and no data is displayed.

You can switch the order that you add the series (Right first and then Left) and you will see the same thing happen on the 2nd axis added every time.

It seems that when the chart is zoomed in, even though the 2nd axis is not visible, the min/max for the axis appears to be getting set.

Is it possible to disable the zooming of the non-visible axis?

I can handle this fine for my custom vertical axes since I have to handle zooming on custom axes anyway. I simply only apply the .SetMinMax() method call when the custom axis in question is visible.
However, for the Left and Right vertical axes it seems to be done automatically.

Thanks.
Aaron

Edu · Post by **Edu** » Wed May 02, 2007 9:35 am

Hi Aaron

No, it isn't possible, because the zoom afect all the chart. You could try not using default axes and use only custom axes for your chart, using the setMinMax() method.

Aaron Peronto · Post by **Aaron Peronto** » Wed May 02, 2007 2:55 pm

Thanks for the reply.
I thought that might be the answer but I was hoping for something else

I think our best bet is to stop using the .LEFT and .RIGHT in the Axes collection on the chart and create 2 more custom axes to place where the LEFT and RIGHT would normally appear.
This will give us full control over those 2 inner axes the same way we control the 4 outer axes we make available.

Thanks again for your quick response.

Aaron