error with chart object

T

Tom

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
 
J

JLGWhiz

It is probably the AutoScaleFont property that threw the error. It is
normally used with Boolean value of True or False. Try using just Font.
 
Top