VBA: Adjust y-axis scale based on 1 data series

[vlad7984]

Hi. I am making a chart with multiple data series. One of them is a fake series that I use to shade so the values are way higher than the normal series I use and excel accounts for that when auto scaling. Is there anyway in VBA where I can specify which data series to base the auto scale?

Thanks.