Macro Sheets Only
Equivalent to the Titles command on the Insert menu when a chart is active. Attaches text to various parts of a chart.
Syntax
2D charts
INSERT.TITLE(chart, y_primary, x_primary, y_secondary, x_secondary)
3D charts
INSERT.TITLE(chart, z_primary, x_primary, y_primary)
Chart is a logical value specifying whether to attach a title to the chart.
Y_primary is a logical value specifying whether to attach a title to the value (y) axis of a 2D chart or the series (y) axis of a 3D chart.
X_primary is a logical value specifying whether to attach a title to the category (x) axis of the chart.
Z_primary is a logical value specifying whether to attach a title to the value (z) axis of a 3D chart.
Y_secondary is a logical value specifying whether to attach a title to the second value (y) axis of a chart containing more than one chart type.
X_secondary is a logical value specifying whether to attach a title to the second category (x) axis of a chart containing more than one chart type.
Remarks
To change the text in a selected title, use the FORMULA function.
Related Functions
FORMULA Enters formulas in a chart
List of Command-Equivalent Functions