[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

chartFormat (PivotChart Format)

Represents the format defined in the PivotChart that is associated with this PivotTable.

[Example:

<sh:pivotTableDefinition xmlns:sh="…" name="PivotTable1" cacheId="0"
applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="0"
applyPatternFormats="0" applyAlignmentFormats="0" applyWidthHeightFormats="1"
dataCaption="Values" updatedVersion="3" minRefreshableVersion="3"
showCalcMbrs="0" useAutoFormatting="1" colGrandTotals="0" itemPrintTitles="1"
createdVersion="3" indent="0" outline="1" outlineData="1"
multipleFieldFilters="0" chartFormat="1" fieldListSortAscending="1">

end example]

Parent Elements

chartFormats3.10.1.13)

 

Child Elements

Subclause

pivotArea (Pivot Area)

§3.3.1.66

 

Attributes

Description

chart (Chart Index)

Specifies the index of the chart part to which the formatting applies. For more information see the DrawingML specification for more information on the chart part.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

format (Pivot Format Id)

Specifies the index of the pivot format that is currently in use. This index corresponds to a dxf element in the Styles part. For more information see the Styles section (§3.8).

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

series (Series Format)

Specifies a boolean value that indicates whether format applies to a series.

 

A value of on, 1, or true indicates this format applies to a series.

 

A value of off, 0, or false indicates this format applies to a data point.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_ChartFormat">

   <sequence>

   <element name="pivotArea" type="CT_PivotArea"/>

   </sequence>

   <attribute name="chart" use="required" type="xsd:unsignedInt"/>

   <attribute name="format" use="required" type="xsd:unsignedInt"/>

   <attribute name="series" type="xsd:boolean" default="false"/>

</complexType>