error with chart object

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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.
 
Back
Top