trendline (Trendlines)

This element specifies a trendline.

Parent Elements

ser (§5.7.2.175); ser (§5.7.2.172); ser (§5.7.2.169); ser (§5.7.2.168); ser (§5.7.2.174)

 

Child Elements	Subclause
backward (Backward)	§5.7.2.12
dispEq (Display Equation)	§5.7.2.43
dispRSqr (Display R Squared Value)	§5.7.2.44
extLst (Chart Extensibility)	§5.7.2.64
forward (Forward)	§5.7.2.73
intercept (Intercept)	§5.7.2.85
name (Trendline Name)	§5.7.2.117
order (Polynomial Trendline Order)	§5.7.2.130
period (Period)	§5.7.2.136
spPr (Shape Properties)	§5.7.2.198
trendlineLbl (Trendline Label)	§5.7.2.213
trendlineType (Trendline Type)	§5.7.2.214

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

<complexType name="CT_Trendline">

   <sequence>

   <element name="name" type="xsd:string" minOccurs="0" maxOccurs="1"/>

   <element name="spPr" type="a:CT_ShapeProperties" minOccurs="0" maxOccurs="1"/>

   <element name="trendlineType" type="CT_TrendlineType" minOccurs="1" maxOccurs="1"/>

   <element name="order" type="CT_Order" minOccurs="0" maxOccurs="1"/>

   <element name="period" type="CT_Period" minOccurs="0" maxOccurs="1"/>

   <element name="forward" type="CT_Double" minOccurs="0" maxOccurs="1"/>

   <element name="backward" type="CT_Double" minOccurs="0" maxOccurs="1"/>

   <element name="intercept" type="CT_Double" minOccurs="0" maxOccurs="1"/>

   <element name="dispRSqr" type="CT_Boolean" minOccurs="0" maxOccurs="1"/>

   <element name="dispEq" type="CT_Boolean" minOccurs="0" maxOccurs="1"/>

   <element name="trendlineLbl" type="CT_TrendlineLbl" minOccurs="0" maxOccurs="1"/>

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

   </sequence>

</complexType>