2.2.3.3 Chart

  • Article

A chart is a graphic that displays data or the relationships between sets of data in a visual form. A chart element is an item within the chart such as an axis (section 2.2.3.6), legend (section 2.2.3.8), series (section 2.2.3.9), data point (section 2.2.3.10), data label (section 2.2.3.11), trendline (section 2.2.3.12), error bar (section 2.2.3.13), or data table (section 2.2.3.14).

A chart data cache (section 2.2.3.2) is specified by a sequence of records that conforms to the CHARTFOMATS rule (section 2.1.7.20.1) specified by the chart sheet substream (section 2.1.7.20.1) ABNF.

A chart can contain the following records and rules that specify the parts of the chart:

  • The Chart record (section 2.4.45) specifies the position and size of the chart area (section 2.2.3.17) for a non-embedded chart.

  • The sequence of records that conforms to the FONTLIST rule (section 2.1.7.20.1) specifies font information for the chart.

  • The Scl record (section 2.4.247) specifies the zoom level of the current view in the window used to display the chart.

  • The PlotGrowth record (section 2.4.198) specifies font scaling for the text on the chart.

  • The sequence of records that conforms to the FRAME rule (section 2.1.7.20.1) specifies formatting of the chart area (section 2.2.3.17).

  • The sequence of records that conforms to the SERIESFORMAT rule (section 2.1.7.20.1) specifies the series, trendlines, and error on the chart.

  • The sequences of records that conform to the SS rule (section 2.1.7.20.1) specify properties of the data labels, series, data points, trendlines, and error bars on the chart. These records MUST NOT exist if the chart sheet substream contains a Series record (section 2.4.252). See the data label overview for additional restrictions on these collections of records.

  • The sequences of records that conform to the DFTTEXT rule (section 2.1.7.20.1) and TEXTPROPS rule (section 2.1.7.20.1) specify default properties of the text in the chart. The DataLabExt (section 2.4.75), StartObject (section 2.4.267), and EndObject (section 2.4.101) records MUST NOT exist in these sequences of records that conform to the DFTTEXT rule (section 2.1.7.20.1).

  • The AxesUsed record (section 2.4.10) and the sequence of records that conforms to the AXISPARENT rule (section 2.1.7.20.1) specify the axis groups (section 2.2.3.5) of the chart.

  • The CrtLayout12A record (section 2.4.67) specifies layout information for the plot area.

  • The sequence of records that conforms to the DAT rule (section 2.1.7.20.1) specifies the data table for the chart.

  • The sequence of records that conforms to the ATTACHEDLABEL rule (section 2.1.7.20.1) specifies the chart title. This sequence of records MUST have an ObjectLink record (section 2.4.182) where the wLinkObj field has a value of 0x0001.

  • The sequence of records that conforms to the ATTACHEDLABEL rule and is preceded by the optional DataLabExt record specifies properties of series and data point data labels. This sequence of records MUST have an ObjectLink record where the wLinkObj field has a value of 0x0004. See the data label overview for additional information and restrictions on this collection of records.

  • The sequence of records that conforms to the CRTMLFRT rule (section 2.1.7.20.1) specifies future records (section 2.1.6) for the chart.