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.