<externalData> (External Data Relationship)

This element specifies the relationship to the data for this chart.

The data may be linked, pointing to a spreadsheet in another file. Or, the data may be embedded, contained in a separate part within the same xml package containing the chart. In this case, it shall be stored as an embedded Spreadsheet object in Open XML format.

This is not used by a spreadsheet application as the spreadsheet application can maintain its own reference to the data in the spreadsheet via the formula <f> element.

Parent Elements


Child Elements


<autoUpdate> (Update Automatically)




<id> (Relationship Reference)

Namespace: .../officeDocument/2006/relationships

Specifies the relationship ID for the relationship for this chart. The relationship explicitly targeted by this attribute shall be of type http://schemas.openxmlformats.org/officeDocument/2006/relationships/package.

The possible values for this attribute are defined by the ST_RelationshipId simple type (§

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

<complexType name="CT_ExternalData">
	<element name="autoUpdate" type="CT_Boolean" minOccurs="0" maxOccurs="1"/>
	<attribute ref="r:id" use="required"/>