Y Axis Auto Scale

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppress X Axis Scaling 1
Y axis 5
Chart - Secondary Y-axis with different values/scale 2
Urgent - X and Y Axis Auto Scale for Chart 3
Logarithmic charts on different axis 1
Data labels along below x axis when y axis has negative values 1
Constant % on X axis 2
dual y-axis align grid, drop line to y axis, add-ins 1

Top