relating to several axes of an diagram with vba

[Kretzer]

Hi,

my problem was nearly solves with this Thread:thread703-538743

Now I know that I can set the maximumsclae of the Y-Aches of an Diagram by using:

    Me.Ranking_VOFI.axes(2).maximumscale = 10

So what i now need to know is. How to reference a second Y-Axes. The Diagram in my report owns one Y-Achses on the left which is referenced like above (axes(2)) but how can I reference the Y-Axes on the right? I tried several other index numbers like axes(1) to axes(8) but in all cases there were errors saying that the value could not be applied...

Hope someone can help

Thank you

 

[Kretzer]

Hi,

found the answer!

Refering to the secondary Y-Axes works like this:

Me.DiagramName.axes(2, 2).maximumscale = value

Maybe someone else needes this answer aswell ;-)

Martin