2.2.3.14 Data Table

A data table (2) is a table on a chart (section 2.2.3.3) that contains a row for each series (section 2.2.3.9) and lists the values of each data point (section 2.2.3.10) on the chart.

A data table (2) is specified by a sequence of records that conforms to a DAT rule (section 2.1.7.20.1) as specified by the chart sheet substream (section 2.1.7.20.1) ABNF.

The following records and rules define the significant parts of a data table (2):

  • The Dat record (section 2.4.73) specifies if the data table (2) shows legend keys next to the name of the series and specifies which data table (2) borders are displayed.

  • The sequences of records that conform to the ATTACHEDLABEL (section 2.1.7.20.1) and TEXTPROPS (section 2.1.7.20.1) rules in the sequence of records that conforms to the LD rule (section 2.1.7.20.1) specify the text formatting for the data table (2). The Pos record (section 2.4.201) of the attached label (section 2.2.3.15) MUST be ignored. The ObjectLink record (section 2.4.182) of the attached label MUST NOT exist.

  • The sequence of records that conforms to the FRAME rule (section 2.1.7.20.1) in the sequence of records that conforms to the LD rule specifies the formatting properties of the data table (2).

The following restrictions apply to the collection of records that represents a data table (2):

  • The fWasDataTable field of the Legend record (section 2.4.152) in the sequence of records that conforms to the LD rule MUST equal 1.

  • The Pos record in the sequence of records that conforms to the LD rule MUST be ignored. A data table (2) is automatically positioned.

  • The CrtLayout12 record (section 2.4.66) and the sequence of records that conforms to the CRTMLFRT rule (section 2.1.7.20.1), in the sequence of records that conforms to the LD rule, MUST NOT exist in a data table (2).

A data table (2) is not displayed on a chart if the chart contains a bar of pie, bubble, doughnut, filled radar, pie, pie of pie, radar, or scatter chart group (section 2.2.3.7).