2.1.7.20.1 Chart Sheet Substream

Office

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

AI = BRAI [SeriesText]

ATTACHEDLABEL = Text Begin Pos [FontX] [AlRuns] AI [FRAME] [ObjectLink] [DataLabExtContents] [CrtLayout12] [TEXTPROPS] [CRTMLFRT] 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

DAT = Dat Begin LD End

GELFRAME = 1*2GelFrame *Continue [PICF]

PICF = Begin PicF End

CRTMLFRT = CrtMlFrt *CrtMlFrtContinue

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.

Show: