2.22.3.10 CT_PivotOptions16

  • Article

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

Referenced by: pivotOptions16

A complex type<208> that specifies additional pivot controls that can appear on the chart ([ISO/IEC29500-1:2016] section 21.2).

Child Elements:

showExpandCollapseFieldButtons: A CT_BooleanFalse element<209> that specifies whether two controls are visible on a PivotChart, an Expand Entire Field button and a Collapse Entire Field button, when pivotOptions:dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

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

 <xsd:complexType name="CT_PivotOptions16">
   <xsd:sequence>
     <xsd:element name="showExpandCollapseFieldButtons" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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