Y Axis Auto Scale

A

Arturo

Morning –
I’m trying to pull the auto scale values from one chart’s Y axis and apply
them to another. I cannot seem to find a way of getting that information, is
there a way?

Arturo
 
A

Andy Pope

Hi,

You can use syntax similar to this.

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

Cheers
Andy
 
Top