error with chart object
 

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

error with chart object
 

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.

"Tom" wrote:

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