ChartFormats Class
PivotChart Formats.When the object is serialized out as xml, its qualified name is x:chartFormats.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.ChartFormats
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(ChartFormat))> _
Public Class ChartFormats _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As ChartFormats
[ChildElementInfoAttribute(typeof(ChartFormat))]
public class ChartFormats : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- ChartFormat <x:chartFormat>
[ISO/IEC 29500-1 1st Edition]
18.10.1.13 chartFormats (PivotChart Formats)
Represents the collection of formats applied to PivotChart.
[Example:
<sh:chartFormats count="4">
<sh:chartFormat chart="0" format="0" series="1">
<sh:pivotArea type="data" outline="0">
<sh:references count="3">
<sh:reference field="4294967294" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="14" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="15" count="1" selected="0">
<sh:x v="2"/>
</sh:reference>
</sh:references>
</sh:pivotArea>
</sh:chartFormat>
<sh:chartFormat chart="0" format="1" series="1">
<sh:pivotArea type="data" outline="0">
<sh:references count="3">
<sh:reference field="4294967294" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="14" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="15" count="1" selected="0">
<sh:x v="3"/>
</sh:reference>
</sh:references>
</sh:pivotArea>
</sh:chartFormat>
<sh:chartFormat chart="0" format="2" series="1">
<sh:pivotArea type="data" outline="0">
<sh:references count="3">
<sh:reference field="4294967294" count="1" selected="0">
<sh:x v="1"/>
</sh:reference>
<sh:reference field="14" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="15" count="1" selected="0">
<sh:x v="2"/>
</sh:reference>
</sh:references>
</sh:pivotArea>
</sh:chartFormat>
<sh:chartFormat chart="0" format="3" series="1">
<sh:pivotArea type="data" outline="0">
<sh:references count="3">
<sh:reference field="4294967294" count="1" selected="0">
<sh:x v="1"/>
</sh:reference>
<sh:reference field="14" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="15" count="1" selected="0">
<sh:x v="3"/>
</sh:reference>
</sh:references>
</sh:pivotArea>
</sh:chartFormat>
</sh:chartFormats>
end example]
Parent Elements |
|---|
pivotTableDefinition (§18.10.1.73) |
Child Elements |
Subclause |
|---|---|
chartFormat (PivotChart Format) |
§18.10.1.12 |
Attributes |
Description |
|---|---|
count (Format Count) |
Specifies the number of formats in the collection. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_ChartFormats) is located in §A.2. end note]
© ISO/IEC29500: 2008.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.