Chart label font colour

[jaffacake]

Hi all,

I'm trying to make the font colour of my chart's secondary vertical and horizontal axis white (or hide them). I've used the macro recorder and get the following code;

Selection.Format.TextFrame2.TextRange.Font.Fill.Visible = msoFalse

When i run this code however i get an error on the TextFrame2 bit.

What am i doing wrong?

Cheers

 

[jaffacake]

Sorted!

With ActiveChart.Axes(xlValue, xlSecondary).TickLabels.Font
.Color = vbWhite
End With