Determines the appearance of the border drawn around the text area, as well as whether a border appears.

Returns the owning chart (read-only)

See

[[owner]]

Defines the font properties for each formatted run in the [[text]] that has no more specific setting. Read-only.

Use this object to apply font formatting to the entire run of text which comprises the chart or axis title.

Font formatting can be applied to individual runs of text using the [[FormattedString.getFont]] method of the object returned from the [[text]] property. Any such formatting overrides that which is defined by the DefaultFont settings.

See

• [[text]]
• [[FormattedString]]

Returns or sets a [[ChartFillBase]] derived object which defines the fill properties for the text area.

This property returns null by default, indicating that no fill is applied.

To apply a solid color fill, assign an instance of the [[ChartSolidFill]] class to this property.

To apply a gradient fill, assign an instance of the [[ChartGradientFill]] class to this property.

See

• [[ChartSolidFill]]
• [[ChartGradientFill]]

The formula used to get the text displayed within the text area. (read-only). To set this property call the SetFormula method.

See

[[setFormula]]

Determines whether text is allowed to continue horizontally outside the bounds of the containing element.

The left position of the text area (ignored unless [[position]] is set to 'Custom').

The value of this property is expressed as a fractional value between 0 and 1 which represents the ratio of the offset to the width of the chart element.

For example, a value of 0 positions the text area as close as possible to the edge of the chart element; a value of 1 positions it as close as possible to the opposite edge. All values in between 0 and 1 represent a scalar which, when applied to the width of the entire chart element, yields the offset.

See

[[position]]

Returns or sets the format to use for numbers.

See

[[numberFormatLinked]]

True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

See

[[numberFormat]]

returns this object's owner. (read-only) The owner or null if this object is owned directly by the Chart

See

[[chart]]

Determines whether the position of the text area is automatic or custom as specified by the [[left]] and [[top]] properties.

Determines the reading order

Determines the rotation of the text area, expressed in degrees.

The owning sheet (read-only)

Returns or sets a [[FormattedString]] object which defines the text to be displayed by the associated chart element.

Because mixed font settings are supported for chart element text, a special object is required to customize the text.

For the simple case where all the text has the same formatting, create an instance of the [[FormattedString]] class, specifiying the text as the value of the 'unformattedString' parameter.

To apply font attributes to a given run of text, i.e., a substring within the text, use the [[FormattedString.getFont]] method, and set the applicable properties of the [[FormattedStringFont]] instance returned from the GetFont method.

See

• [[FormattedString..ctor]]
• [[FormattedString.getFont]]

Determines the orientation and direction in which text flows.

Note that the [[rotation]] property is only applicable when this property is set to Horizontal.

See

[[rotation]]

The top position of the text area (ignored unless [[position]] is set to 'Custom').

The value of this property is expressed as a fractional value between 0 and 1 which represents the ratio of the offset to the height of the associated chart element.

For example, a value of 0 positions the title as close as possible to the edge of the associated chart element; a value of 1 positions it as close as possible to the opposite edge. All values in between 0 and 1 represent a scalar which, when applied to the height of the entire chart element, yields the offset.

See

[[position]]

Determines the vertical alignment of the text area.

Determines whether text is allowed to continue vertically outside the bounds of the containing element.

The owning workbook (read-only)

The owning worksheet (read-only)

Determines whether text is wrapped when it would exceed the bounds of the containing element.

Assigns a new [[Formula]] to this instance.

See

[[text]]