Share via

2.6.3.1 CT_CategoryFilterException

  • Article

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

Referenced by: CT_CategoryFilterExceptions

CT_CategoryFilterException is a complex type that contains information about special formatting properties associated with a single data point in a chart series ([ISO/IEC29500-1:2016] section 21.2).<69> This complex type is used to save special data point properties of points that are filtered out of the chart series ([ISO/IEC29500-1:2016] section 21.2). An entry of this type MUST contain exactly one sqref element followed by one or more child elements.

Child Elements:

sqref: A string element ([XMLSCHEMA2/2] section 3.2.1) that specifies the cell reference of the data corresponding to this data point in the chart series ([ISO/IEC29500-1:2016] section 21.2). This element is required. This reference MUST follow the ABNF grammar rules defined in the Formulas section ([MS-XLSX] section 2.2.2) with the following restrictions:

  • MUST follow the single-sheet-reference rule.

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

  • MUST use only A1-cell, A1-absolute-column, and A1-absolute-row (since a data point in a series can correspond to only one cell, it SHOULD NOT use area references).

An application can adjust this cell reference 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.

spPr: A CT_ShapeProperties element ([ISO/IEC29500-1:2016] section A.4.1) that specifies the formatting (like fill or line properties) to be shown on this data point.

explosion: A CT_UnsignedInt element ([ISO/IEC29500-1:2016] section A.5.1) that specifies the amount this data point shall be moved from the center of the pie in a pie chart series.

invertIfNegative: A CT_Boolean element ([ISO/IEC29500-1:2016] section A.5.1) that specifies if the invert color is shown when this data point has a negative value.

bubble3D: A CT_Boolean element ([ISO/IEC29500-1:2016] section A.5.1) that specifies if this data point has a 3D bubble.

marker: A CT_Marker element ([ISO/IEC29500-1:2016] section A.5.1) that specifies the properties of the line marker associated with this data point.

dLbl: A CT_DLbl element ([ISO/IEC29500-1:2016] section A.5.1) that specifies the properties of the Datalabel (section 2.2.1.3) associated with this data point.

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

 <xsd:complexType name="CT_CategoryFilterException">
   <xsd:sequence>
     <xsd:element name="sqref" type="xsd:string" minOccurs="1" maxOccurs="1"/>
     <xsd:element name="spPr" type="a:CT_ShapeProperties" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="explosion" type="c:CT_UnsignedInt" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="invertIfNegative" type="c:CT_Boolean" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="bubble3D" type="c:CT_Boolean" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="marker" type="c:CT_Marker" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="dLbl" type="c:CT_DLbl" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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