Referencing the Seconday Y axis scale values in code

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!

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...b;en-us;213695

Cheers,
Katherine

"Ken Ramirez" wrote in message
...
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!

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


Ken Ramirez wrote:

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