| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Object Error 91 | Excel Discussion (Misc queries) | |||
| Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
| Cannot Activate Chart Area in Chart. Chart Object Failed | Excel Programming | |||
| Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Hybrid Mode
