Auto Scale Chart Font in Excel 2007

[geekgirlau]

Can't find the option, and my belief is that Microsoft have chosen to remove it.


Quick workaround if required (although I'm sure there are other ways to accomplish this):

[VBA]
Dim cht As ChartObject


For Each cht In shGraphs.ChartObjects
cht.Chart.Legend.Font.Size = 14
cht.Chart.Legend.Position = xlLegendPositionRight
Next cht

[/VBA]

I've attached this to a worksheet event that causes a recalculation.

[Bob Phillips]

I believe that you are correct. It even seems that although the property has been retained in the OM and you can set it in VBA, it has no effect (sic!).