Share via

2.6.9 CT_Sparkline

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_Sparklines

CT_Sparkline is a complex type that specifies information for a single sparkline.

Child Elements:

xm:f: An f element (section 2.4.3) that specifies the data range for this sparkline. The syntax, specified in section 2.2.2, for this element is the following:

 sparkline-formula = single-sheet-area / [single-sheet-prefix / book-prefix] name

Additionally, if a single-sheet-area is specified, that single-sheet-area MUST contain cells from either a single row or a single column.

xm:sqref: A sqref element (section 2.4.5) that specifies the cell in which the sparkline is located. This sqref element MUST contain exactly one ref element (section 2.4.4) that MUST specify exactly one cell.

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

 <xsd:complexType name="CT_Sparkline">
   <xsd:sequence>
     <xsd:element ref="xm:f" minOccurs="0" maxOccurs="1"/>
     <xsd:element ref="xm:sqref" minOccurs="1" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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