Y Axis Auto Scale
 

Morning €“
Im trying to pull the auto scale values from one charts Y axis and apply
them to another. I cannot seem to find a way of getting that information, is
there a way?

Arturo

Y Axis Auto Scale
 

Hi,

You can use syntax similar to this.

Msgbox activechart.Axes(xlvalue,xlPrimary).maximumscale
Msgbox activechart.Axes(xlvalue,xlPrimary).minimumscale

Cheers
Andy

Arturo wrote:
Morning €“
Im trying to pull the auto scale values from one charts Y axis and apply
them to another. I cannot seem to find a way of getting that information, is
there a way?

Arturo

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info