AutoScaleFont Property
Applies To
AxisTitle object, ChartArea object, ChartTitle object, DataLabel object, DataLabels Collection object, DataTable object, Legend object, LegendEntry object, TickLabels object.
Description
True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant.
Example
This example adds a title to the chart, and it causes the title font to remain the same size whenever the chart size changes.
With myChart
.HasTitle = True
.ChartTitle.Text = "1996 sales"
.ChartTitle.AutoScaleFont = False
End With