2.2.3.15 Attached Label

  • Article

An attached label is a generic text element that is used on a chart (section 2.2.3.3). An attached label can specify properties of an axis (section 2.2.3.6) title, chart title, data label (section 2.2.3.11), data table (section 2.2.3.14), display units label, legend (section 2.2.3.8), legend entry, trendline (section 2.2.3.12) label, or the default text properties of the entire chart.

The location of the attached label in the chart sheet substream (section 2.1.7.20.1) ABNF and the properties of the ObjectLink record (section 2.4.182) of the attached label specify the chart element to which the attached label applies. Refer to the conceptual overviews (section 2.2.3) for explanation of the meaning of the attached label in each context that it is used.

An attached label is specified by a collection of records that conforms to an ATTACHEDLABEL rule (section 2.1.7.20.1) as specified by the chart sheet substream (section 2.1.7.20.1) ABNF.

  • The Text record (section 2.4.324) and the collection of records that conforms to the TEXTPROPS rule (section 2.1.7.20.1) specify properties of the text in the attached label. These properties include text options such as text rotation and reading order. On attached labels that represent data labels, the Text record also specifies content and layout properties of the data labels.

  • The Pos (section 2.4.201) and CrtLayout12 (section 2.4.66) records specify the position of the attached label on the chart. The Pos record MUST be ignored if the attached label represents the data labels on a series (section 2.2.3.9) or chart group (section 2.2.3.7), a data table, the default text of the chart, or a legend key.

  • The FontX (section 2.4.123) and AlRuns (section 2.4.1) records specify the font and rich text formatting properties of the attached label.

  • The collection of records that conforms to the AI rule (section 2.1.7.20.1) specifies custom text of the attached label.

  • The collection of records that conforms to the FRAME rule (section 2.1.7.20.1) specifies the fill and border properties of the attached label.

  • The ObjectLink record specifies the chart element the attached label applies to.

  • The DataLabExtContents record (section 2.4.76) specifies additional data label properties on attached labels that represent a data label. Refer to the data label overview for the conditions when this record can be written. This record MUST NOT exist unless the attached label specifies properties of a data label. An attached label specifies properties of a data label if the wLinkObj field of the ObjectLink record is equal to 0x0004 or the attached label is in the collection of records that conforms to the DFTTEXT rule (section 2.1.7.20.1) in a chart group.

  • The collection of records that conforms to the CRTMLFRT rule (section 2.1.7.20.1) specifies future records (section 2.1.6) for the attached label.