Share via

2.6.3.17 CT_LevelRef

  • Article

Target namespace: http://schemas.microsoft.com/office/drawing/2012/chart

Referenced by: levelRef

The CT_LevelRef is a complex type that specifies the data source reference for the currently selected label level within a hierarchical set of labels for a chart ([ISO/IEC29500-1:2016] section 21.2) category axis or a chart series title.<85>

This reference is in the form of a book, sheet, and cell reference. This reference does not include the equals sign.

Child Elements:

sqref: A string element ([XMLSCHEMA2/2] section 3.2.1) that specifies the data source reference for the chart data for the associated caption level. This reference MUST follow the ABNF grammar rules defined in Formulas ([MS-XLSX] section 2.2.2) with the following restrictions:

  • MUST follow the single-sheet-reference rule.

  • MUST NOT use the A1-relative-column and A1-relative-row rules.

  • MUST only use A1-absolute-column and A1-absolute-row.

An application can adjust these cell references when the worksheet layout changes, even when the containing ext element ([ISO/IEC29500-1:2016] section 18.2.7) is not recognized by the application.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_LevelRef">
   <xsd:sequence>
     <xsd:element name="sqref" type="xsd:string" minOccurs="1" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

See section 5.13 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).