Share via

2.2.3.1 Chart Sheet

  • Article

A chart sheet is a set of data and the chart (section 2.2.3.3) that displays the data. There are two types of chart sheets: embedded chart sheets, and chart sheets that are not embedded.

A chart sheet that is not embedded is a separate sheet (1) in the workbook that is intended to display a chart. An embedded chart sheet is the logical container for a chart displayed on a worksheet.

A chart sheet is specified by the chart sheet substream (section 2.1.7.20.1).

The chart sheet substream for an embedded chart sheet is contained within a worksheet substream (section 2.1.7.20.5). A chart sheet that is not embedded is specified by a chart sheet substream that is not contained in another substream.

The following records and rules specify the significant parts of a chart sheet:

  • The SheetExt record (section 2.4.259) specifies properties of the sheet (1) containing the chart. If the chart sheet is embedded, the SheetExt record MUST NOT exist.

  • The WebPub record (section 2.4.344) specifies properties of a chart sheet that has been published to the web.

  • The sequences of records that conform to the PAGESETUP rule (section 2.1.7.20.6) and BACKGROUND rule (section 2.1.7.20.6) and the HFPicture (section 2.4.138), PrintSize (section 2.4.204), and HeaderFooter (section 2.4.137) records specify information about how the chart is printed.

  • The Fbi (section 2.4.109) and Fbi2 (section 2.4.110) records specify properties used for font scaling on the chart.

  • The Palette (section 2.4.188) and ClrtClient (section 2.4.50) records specify properties of the color palettes used in the chart sheet.

  • The sequence of records that conforms to the PROTECTION rule (section 2.1.7.20.6) and the WriteProtect record (section 2.4.350) specify protection settings for the chart. If the chart sheet is embedded, the WriteProtect record MUST NOT exist.

  • The SXViewLink (section 2.4.316), PivotChartBits (section 2.4.196), and SBaseRef (section 2.4.242) records specify the PivotTable (section 2.2.5) that is the data source for this chart. If the chart is not a Pivot Chart (section 2.2.3.4) these records MUST be ignored.

  • The sequence of records that conforms to the OBJECTS rule (section 2.1.7.20.6) and the MsoDrawingGroup record (section 2.4.171) specify the drawing objects on the chart

  • The sequence of records that conforms to the CHARTFOMATS rule (section 2.1.7.20.6) specifies the chart that is contained in the chart sheet.

  • The sequence of records that conforms to the SERIESDATA rule (section 2.1.7.20.6) specifies the chart data cache (section 2.2.3.2).

  • The sequences of records that conform to the WINDOW rule (section 2.1.7.20.6) and CUSTOMVIEW rule (section 2.1.7.20.6) specify the sheet (1) that contains the chart. If the chart sheet is not embedded, at least one sequence of records that conform to the WINDOW rule MUST exist. If the chart sheet is embedded, a sequence of records that conforms to the WINDOW rule and CUSTOMVIEW rule MUST NOT exist.

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