VBA to set the font size for the axes of a bar chart
 

I trying to set the font size on the axes of a horizontal stacked bar
chart (Excel 2010). When I try to run the code created by the macro
recorder I get an error message: Method of 'TextFrame2' of object
'ChartFormat' failed

Here is the offending code:

ActiveChart.Axes(xlValue).Select
Selection.Format.TextFrame2.TextRange.Font.Size = 10

Can anyone tell me how to set the font size of the chart axes with VBA
please?
Any help would be greatly appreciated.

VBA to set the font size for the axes of a bar chart
 

On Sep 6, 8:08*pm, Harry Flashman wrote:
I trying to set the font size on the axes of a horizontal stacked bar
chart (Excel 2010). When I try to run the code created by the macro
recorder I get an error message: Method of 'TextFrame2' of object
'ChartFormat' failed

Here is the offending code:

ActiveChart.Axes(xlValue).Select
* * Selection.Format.TextFrame2.TextRange.Font.Size = 10

Can anyone tell me how to set the font size of the chart axes with VBA
please?
Any help would be greatly appreciated.

Okay I am an idiot. After struggling with this problem for over an
hour I post here and then exactly 2 minutes later I figure it out.


ActiveChart.Axes(xlValue).TickLabels.Font.Size = 10
ActiveChart.Axes(xlCategory).TickLabels.Font.Size = 8