Share via


ChartTitle.AutoScaleFont Property

Excel Developer Reference

True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant.

Syntax

expression.AutoScaleFont

expression   A variable that represents a ChartTitle object.

Example

This example adds a title to embedded chart one on the active worksheet, and it causes the title font to remain the same size whenever the chart size changes.

Visual Basic for Applications
  With ActiveSheet.ChartObjects(1).Chart
    .HasTitle = True
    .ChartTitle.Text = "1996 sales"
    .ChartTitle.AutoScaleFont = False
End With