I have a bunch of charts embedded in a worksheet and I am trying to change
the font size on the axis using vb.

My code is:


For iChart = 1 To nCharts

With ActiveSheet.ChartObjects(iChart).Axes(xlCategory)
..TickLabels.AutoScaleFont.Size = 9
End With

However I get an error: object does not support this property or method