PDA

View Full Version : Auto Scale Chart Font in Excel 2007



geekgirlau
09-21-2009, 06:03 PM
Can't find the option, and my belief is that Microsoft have chosen to remove it.
:igiveup:

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


Dim cht As ChartObject


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



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

Bob Phillips
09-22-2009, 01:38 AM
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!).