Share via

2.7.3.4 CT_PivotOptions

  • Article

Target namespace: http://schemas.microsoft.com/office/drawing/2007/8/2/chart

Referenced by: pivotOptions

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

Child Elements:

dropZoneFilter: A CT_BooleanFalse element that specifies whether a control for each PivotTable field ([ISO/IEC29500-1:2016] section 18.10) on the PivotTable page axis ([ISO/IEC29500-1:2016] section 18.10) of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element ([ISO/IEC29500-4:2016] section A.5.1) does not have a child CT_PivotSource element ([ISO/IEC29500-4:2016] section A.5.1).

dropZoneCategories: A CT_BooleanFalse element that specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

dropZoneData: A CT_BooleanFalse element that specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

dropZoneSeries: A CT_BooleanFalse element that specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on the chart when dropZonesVisible is set to TRUE. MUST NOT exist if the parent CT_ChartSpace element does not have a child CT_PivotSource element.

dropZonesVisible: A CT_BooleanFalse element that specifies whether any pivot controls can appear on the pivot chart. For example, if dropZoneFilter and dropZoneCategories are set to TRUE and dropZoneData and dropZoneSeries are set to FALSE, if dropZonesVisible is set to TRUE, controls corresponding to PivotTable fields on the PivotTable page axis and PivotTable row axis appear on the chart, and if dropZonesVisible is set to FALSE, no controls appears on the chart. 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_PivotOptions">
   <xsd:sequence>
     <xsd:element name="dropZoneFilter" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="dropZoneCategories" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="dropZoneData" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="dropZoneSeries" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="dropZonesVisible" type="CT_BooleanFalse" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
 </xsd:complexType>

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