Setting Axis Title Orientation in VBA

[MrPogle]

I am trying to use the ActiveChart.SetElement method to turn a secondary y-axis title to face inwards i.e. the title is on the right of the chart but I want its base to be on the left of the now vertical box (turning your head to the right to read it).

The options prompted with .SetElement are:

.SetElement (msoElementSecondaryValueAxisTitleRotated)
.SetElement (msoElementSecondaryValueAxisTitleHorizontal)
.SetElement (msoElementSecondaryValueAxisTitleNone)
.SetElement (msoElementSecondaryValueAxisTitleVertical)

None of which give me what I need.

The equivalent done manually is "Rotate All Text 90 (degrees)"

.SetElement (msoElementSecondaryValueAxisTitleRotated) is the equivalent of "Rotate All Text 270 (degrees)"

 

[GlennUK]

How about something like this instead:

    With ActiveChart.Axes(xlValue, xlSecondary)
        .AxisTitle.Orientation = -4170
    End With

?

 

[pgc01]

Same as Glenn's

    With ActiveChart.Axes(xlValue, xlSecondary)
        .AxisTitle.Orientation = xlDownward
    End With