Share via

2.22.3.2 CT_CategoryFilterException

  • Article

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

Referenced by: CT_CategoryFilterExceptions

A complex type<184> that specifies an exception data point for a filtered category in a series.

Child Elements:

uniqueId: A CT_ChartUniqueID element<185> that specifies the unique ID of a data point in the parent series. The exceptional properties stored in this complex type belong to that data point. The data point is filtered out from the chart series.

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

explosion: A CT_UnsignedInt ([ISO/IEC29500-1:2016] section A.5.1) element<187> 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 ([ISO/IEC29500-1:2016] section A.5.1) element<188> that specifies whether the invert color is shown when this data point has a negative value.

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

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

dLbl: A CT_DLbl ([ISO/IEC29500-1:2016] section A.5.1) element<191> 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="uniqueId" type="CT_ChartUniqueID" minOccurs="1" maxOccurs="1"/>
     <xsd:element ref="spPr" minOccurs="0" maxOccurs="1"/>
     <xsd:element ref="explosion" minOccurs="0" maxOccurs="1"/>
     <xsd:element ref="invertIfNegative" minOccurs="0" maxOccurs="1"/>
     <xsd:element ref="bubble3D" minOccurs="0" maxOccurs="1"/>
     <xsd:element ref="marker" minOccurs="0" maxOccurs="1"/>
     <xsd:element ref="dLbl" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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