Changing the font of an axis in a pivot chart

**phrankndonna** · 06-25-2012, 06:03 PM

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

**Andy Pope** · 06-26-2012, 03:49 AM

try

ActiveChart.Axes(xlCategory).TickLabels.Font.Size = 9

**phrankndonna** · 06-26-2012, 10:02 AM

Hi, Unfortunately, I must not have something declared or set correctly, because I'm still getting a 'Object variable or With block variable not set' error message.