PivotAxis element

Specifies additional information about a PivotTable axis or location.

Usage

      
<PivotAxis
	Style="xsd:string"
/>

Element Information

Element type PivotAxisType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
PivotTable Contains information about a PivotTable view.

Child Elements

Element Description
DisplayEmptyMembers Specifies a Boolean value indicating whether empty items should be displayed in the PivotTable view.
Label This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
Caption This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
NotVisible This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
Orientation Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis.

Attributes

Attribute Type Required Description Possible Values
Style xsd:string required This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. See external namespace.

Definition

      
<xsd:element name="PivotAxis" type="PivotAxisType" minOccurs="0" maxOccurs="unbounded" >
</xsd:element>
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp