2.1.7.20.1 Chart Sheet Substream
The Chart Sheet Substream specifies either a separate chart sheet that contains a single chart, or an embedded chart object (section 2.2.3.1) contained within a worksheet (section 2.1.7.20.5) or macro sheet (section 2.1.7.20.4).
If a record in the ABNF grammar for this substream is one of the following: Font (section 2.4.122), Continue (section 2.4.58), LineFormat (section 2.4.156), AreaFormat (section 2.4.3), SeriesText (section 2.4.254), DefaultText (section 2.4.88), Text (section 2.4.324), FontX (section 2.4.123), ObjectLink (section 2.4.182), Frame (section 2.4.128), Begin (section 2.4.17), End (section 2.4.99), PicF (section 2.4.193), Pos (section 2.4.201), AlRuns (section 2.4.1), BRAI (section 2.4.29), Fbi (section 2.4.109), or GelFrame (section 2.4.131), and is in a collection specified by StartObject (section 2.4.267) and EndObject (section 2.4.101), that record MUST be replaced by an FrtWrapper record (section 2.4.130) and the wrappedRecord field of that FrtWrapper record MUST specify the record that is replaced. StartBlock record (section 2.4.266) and EndBlock record (section 2.4.100) pairs and ChartFrtInfo (section 2.4.49) are omitted from the ABNF grammar. See section 2.1.6.1 and the respective record specifications for more information.
Record sequence<2> ABNF:
CHARTSHEETCONTENT = [WriteProtect] [SheetExt] [WebPub] *HFPicture PAGESETUP PrintSize [HeaderFooter] [BACKGROUND] *Fbi *Fbi2 [ClrtClient] [PROTECTION] [Palette] [SXViewLink] [PivotChartBits] [SBaseRef] [MsoDrawingGroup] OBJECTS Units CHARTFOMATS SERIESDATA *WINDOW *CUSTOMVIEW [CodeName] [CRTMLFRT] EOF
CHARTSHEET = BOF CHARTSHEETCONTENT
CHARTFOMATS = Chart Begin *2FONTLIST Scl PlotGrowth [FRAME] *SERIESFORMAT *SS ShtProps *2DFTTEXT AxesUsed 1*2AXISPARENT [CrtLayout12A] [DAT] *ATTACHEDLABEL [CRTMLFRT] *([DataLabExt StartObject] ATTACHEDLABEL [EndObject]) [TEXTPROPS] *2CRTMLFRT End
FONTLIST = FrtFontList StartObject *(Font [Fbi]) EndObject
AXISPARENT = AxisParent Begin Pos [AXES] 1*4CRT End
SERIESDATA = Dimensions 3(SIIndex *(Number / BoolErr / Blank / Label))
AXES = [IVAXIS DVAXIS [SERIESAXIS] / DVAXIS DVAXIS] *3ATTACHEDLABEL [PlotArea FRAME]
IVAXIS = Axis Begin [CatSerRange] AxcExt [CatLab] AXS [CRTMLFRT] End
DVAXIS = Axis Begin [ValueRange] [AXM] AXS [CRTMLFRT] End
SERIESAXIS = Axis Begin [CatSerRange] AXS [CRTMLFRT] End
CRT = ChartFormat Begin (Bar / Line / (BopPop [BopPopCustom]) / Pie / Area / Scatter / Radar / RadarArea / Surf) CrtLink [SeriesList] [Chart3d] [LD] [2DROPBAR] *4(CrtLine LineFormat) *2DFTTEXT [DataLabExtContents] [SS] *4SHAPEPROPS End
LD = Legend Begin Pos ATTACHEDLABEL [FRAME] [CrtLayout12] [TEXTPROPS] [CRTMLFRT] End
SERIESFORMAT = Series Begin 4AI *SS (SerToCrt / (SerParent (SerAuxTrend / SerAuxErrBar))) *(LegendException [Begin ATTACHEDLABEL [TEXTPROPS] End]) End
FRAME = Frame Begin LineFormat AreaFormat [GELFRAME] [SHAPEPROPS] End
SS = DataFormat Begin [Chart3DBarShape] [LineFormat AreaFormat PieFormat] [SerFmt] [GELFRAME] [MarkerFormat] [AttachedLabel] *2SHAPEPROPS [CRTMLFRT] End
SHAPEPROPS = ShapePropsStream *ContinueFrt12
TEXTPROPS = (RichTextStream / TextPropsStream) *ContinueFrt12
AXS = [IFmtRecord] [Tick] [FontX] *4(AxisLine LineFormat) [AreaFormat] [GELFRAME] *4SHAPEPROPS [TextPropsStream *ContinueFrt12]
DFTTEXT = [DataLabExt StartObject] DefaultText ATTACHEDLABEL [EndObject]
DROPBAR = DropBar Begin LineFormat AreaFormat [GELFRAME] [SHAPEPROPS] End
AXM = YMult StartObject ATTACHEDLABEL EndObject
For ABNF rules not listed here, see section 2.1.7.20.6. Within the sequence of records specified by the CUSTOMVIEW rule (section 2.1.7.20.6) specified in section 2.1.7.20.6, the Selection (section 2.4.248), HorizontalPageBreaks (section 2.4.142), and VerticalPageBreaks (section 2.4.343) records MUST NOT be present.