[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

chartsheet (Chart Sheet)

This is the root element of Sheet Parts that are of type 'chartsheet'.

Parent Elements

Root element of SpreadsheetML Chartsheet part


Child Elements


customSheetViews (Custom Chart Sheet Views)


drawing (Drawing)


extLst (Future Feature Data Storage Area)


headerFooter (Header Footer Settings)


legacyDrawing (Legacy Drawing Reference)


legacyDrawingHF (Legacy Drawing Reference in Header Footer)


pageMargins (Page Margins)


pageSetup (Chart Sheet Page Setup)


picture (Background Image)


sheetPr (Chart Sheet Properties)


sheetProtection (Chart Sheet Protection)


sheetViews (Chart Sheet Views)


webPublishItems (Web Publishing Items)


The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Chartsheet">


   <element name="sheetPr" type="CT_ChartsheetPr" minOccurs="0" maxOccurs="1"/>

   <element name="sheetViews" type="CT_ChartsheetViews" minOccurs="1" maxOccurs="1"/>

   <element name="sheetProtection" type="CT_ChartsheetProtection" minOccurs="0" maxOccurs="1"/>

   <element name="customSheetViews" type="CT_CustomChartsheetViews" minOccurs="0" maxOccurs="1"/>

   <element name="pageMargins" minOccurs="0" type="CT_PageMargins"/>

   <element name="pageSetup" type="CT_CsPageSetup" minOccurs="0" maxOccurs="1"/>

   <element name="headerFooter" minOccurs="0" type="CT_HeaderFooter"/>

   <element name="drawing" type="CT_Drawing" minOccurs="1" maxOccurs="1"/>

   <element name="legacyDrawing" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>

   <element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>

   <element name="picture" type="CT_SheetBackgroundPicture" minOccurs="0" maxOccurs="1"/>

   <element name="webPublishItems" type="CT_WebPublishItems" minOccurs="0" maxOccurs="1"/>

   <element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>