Referencing the Seconday Y axis scale values in code

[Ken Ramirez]

Does anyone know how to Reference the Seconday Y axis
scale values in code? I am automating a spreadsheet that
uses a chart and i need to adjust these values at run
time. I'm using Visual Basic.

Thanks!

 

[Katherine Coombs]

Hi Ken,

I have absolutely no idea when it comes to coding but the following KB
article may point you in the right direction?

http://support.microsoft.com/default.aspx?scid=kb;en-us;213695

Cheers,
Katherine

 

[Andy Pope]

Hi Ken,

Code generated via macro recorder.

Sub Macro1()
' The Excel constants are
' xlValue = 2
' xlSecondary = 2
'
ActiveChart.Axes(xlValue, xlSecondary).Select
With ActiveChart.Axes(xlValue, xlSecondary)
.MinimumScale = 1
.MaximumScale = 4
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With
End Sub

Does anyone know how to Reference the Seconday Y axis
scale values in code? I am automating a spreadsheet that
uses a chart and i need to adjust these values at run
time. I'm using Visual Basic.

Thanks!

--

Cheers
Andy

http://www.andypope.info