Share via

2.3.32 CT_ChartMetaData

  • Article

Referenced by: CT_Image

Additional data pertaining to worksheet images that have Type chart.

Attributes:

ChartCategory: Specifies the category of the chart.

IsStackedType: Specifies whether the chart is a stacked type.

Is100PercentStackedType: Specifies whether the chart is a 100% stacked type of chart.

HasSimpleDataRange: Specifies whether the chart data table corresponds to a rectangular range of cells in the worksheet.

DataRangeForDisplay: Text representing the chart data table.

IsPivotChart: Specifies whether the chart data table overlaps a PivotTable.

RequiresConnection: Specifies whether the PivotTable, which overlaps the chart data table, requires an external data connection (2) to update the contents of that PivotTable. MUST be true if the PivotTable requires an external data connection (2) to update the contents of the PivotTable.

ExternalSourceIndex: An identifier that the protocol server uses to identify the data connection (2) used to update the contents of the PivotTable which overlaps the chart data table.

FieldListVersion: A unique identifier for the state of the fields of the PivotTable, which overlaps the chart data table, on the protocol server.

FieldWellVersion: A unique identifier for the state of the PivotTable, which overlaps the chart data table, on the protocol server.

DataSourceEmpty: Specifies whether the chart data table has no cells in it.

HasNoVisibleSeries: Specifies whether the chart data table contains no visible series.

IsActionable: Specifies whether the chart contains interactive elements. MUST be true if the chart contains interactive elements.

IsOlap: Specifies whether the chart represents OLAP data. MUST be true if the chart represents OLAP data.

SupportsBIExplore: Specifies whether the chart supports data exploration. MUST be true if the chart support data exploration.

DataConnectionName: Specifies the connection name of the data connection (2) used to update the contents of the PivotTable which overlaps the chart data table.

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

 <xs:complexType name="CT_ChartMetaData">
   <xs:sequence/>
   <xs:attribute name="ChartCategory" type="ST_enmChartCategory" use="required"/>
   <xs:attribute name="IsStackedType" type="xs:boolean" use="required"/>
   <xs:attribute name="Is100PercentStackedType" type="xs:boolean" use="required"/>
   <xs:attribute name="HasSimpleDataRange" type="xs:boolean" use="optional"/>
   <xs:attribute name="DataRangeForDisplay" type="xs:string" use="optional"/>
   <xs:attribute name="IsPivotChart" type="xs:boolean" use="optional"/>
   <xs:attribute name="RequiresConnection" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="ExternalSourceIndex" type="ST_nonNegativeInteger" default="0" use="optional"/>
   <xs:attribute name="FieldListVersion" type="xs:int" use="optional"/>
   <xs:attribute name="FieldWellVersion" type="xs:int" use="optional"/>
   <xs:attribute name="DataSourceEmpty" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="HasNoVisibleSeries" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="IsActionable" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="IsOlap" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="SupportsBIExplore" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="DataConnectionName" type="xs:string" use="optional"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).