Hi All,

This is a "Charting through VBA" question.


Is there any way to specify features for the secundary axis differen
for those of the Y axis (Xlvalue ).


I´ve tried this but it didn´t work.

For the main Y axis

With ActiveChart.Axes(xlValue)

.HasTitle = True
.HasMinorGridlines = False
.HasMajorGridlines = False
.AxisTitle.Orientation = xlHorizontal
.AxisTitle.Text = "M€"
.TickLabels.Orientation = xlHorizontal
.TickLabels.Font.Size = 8

End With

For the Secondary axis

With ActiveChart.Axes(xlSecondary)

.HasTitle = True
.AxisTitle.Orientation = xlHorizontal
.AxisTitle.Text = "hh€"
.TickLabels.Orientation = xlHorizontal
.TickLabels.Font.Size = 8

End With


I,ve even tried

With ActiveChart.Axes.Item(2)

No way


Could anybody give me a clue over how to achieve it ?

Thank

--
ignhde
Posted from - http://www.officehelp.i