Y Axis Auto Scale

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,

You can use syntax similar to this.

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

Cheers
Andy
 
Back
Top