If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Referencing the Seconday Y axis scale values in code
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! |
#3
|
|||
|
|||
Referencing the Seconday Y axis scale values in code
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 |
Thread Tools | |
Display Modes | |
|
|