Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inExcel.Interfaces.ChartTitleUpdateData interface
An interface for updating data on the ChartTitle object, for use in chartTitle.set({ ... }).
Properties
| format | Represents the formatting of a chart title, which includes fill and font formatting. |
| horizontal |
Specifies the horizontal alignment for chart title. |
| left | Specifies the distance, in points, from the left edge of chart title to the left edge of chart area. Value is |
| overlay | Specifies if the chart title will overlay the chart. |
| position | Represents the position of chart title. See |
| show |
Represents a boolean value that determines if the chart title has a shadow. |
| text | Specifies the chart's title text. |
| text |
Specifies the angle to which the text is oriented for the chart title. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text. |
| top | Specifies the distance, in points, from the top edge of chart title to the top of chart area. Value is |
| vertical |
Specifies the vertical alignment of chart title. See |
| visible | Specifies if the chart title is visible. |
format
Represents the formatting of a chart title, which includes fill and font formatting.
format?: Excel.Interfaces.ChartTitleFormatUpdateData;Property Value
Remarks
horizontalAlignment
Specifies the horizontal alignment for chart title.
horizontalAlignment?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";Property Value
Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed"
Remarks
left
Specifies the distance, in points, from the left edge of chart title to the left edge of chart area. Value is null if the chart title is not visible.
left?: number;Property Value
number
Remarks
overlay
Specifies if the chart title will overlay the chart.
overlay?: boolean;Property Value
boolean
Remarks
position
Represents the position of chart title. See Excel.ChartTitlePosition for details.
position?: Excel.ChartTitlePosition | "Automatic" | "Top" | "Bottom" | "Left" | "Right";Property Value
Excel.ChartTitlePosition | "Automatic" | "Top" | "Bottom" | "Left" | "Right"
Remarks
showShadow
Represents a boolean value that determines if the chart title has a shadow.
showShadow?: boolean;Property Value
boolean
Remarks
text
Specifies the chart's title text.
text?: string;Property Value
string
Remarks
textOrientation
Specifies the angle to which the text is oriented for the chart title. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text.
textOrientation?: number;Property Value
number
Remarks
top
Specifies the distance, in points, from the top edge of chart title to the top of chart area. Value is null if the chart title is not visible.
top?: number;Property Value
number
Remarks
verticalAlignment
Specifies the vertical alignment of chart title. See Excel.ChartTextVerticalAlignment for details.
verticalAlignment?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";Property Value
Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed"
Remarks
visible
Specifies if the chart title is visible.
visible?: boolean;Property Value
boolean