Changing the font of an axis in a pivot chart

[phrankndonna]

Hi. I recorded a macro to change the font size of my pivot chart, but when I run the macro, it crashes with the error message of object not set. Below are the few lines of code that recorded. What might be wrong? Thanks.

    ActiveChart.ChartArea.Select
    ActiveChart.Axes(xlCategory).Select
    With Selection.Format.TextFrame2.TextRange.Font
        .BaselineOffset = 0
        .Size = 9
    End With

Frank