2.4.250 SerAuxTrend
The SerAuxTrend record specifies a trendline.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
regt |
ordUser |
numIntercept |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
fEquation |
fRSquared |
|||||||||||||||||||||||||||||
|
numForecast |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
numBackcast |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
regt (1 byte): An unsigned integer that specifies the type of trendline. The value MUST be one of the following values:
-
Value
Meaning
0x00
Polynomial
0x01
Exponential
0x02
Logarithmic
0x03
Power
0x04
ordUser (1 byte): An unsigned integer that specifies the polynomial order or moving average period. MUST be greater than or equal to 0x02 and less than or equal to 0x06 if regt is equal to 0x00; MUST be greater than or equal to 0x02 and less than or equal to the value of the cValx field of the Series record specified by the preceding SerParent record minus one if regt is equal to 0x04. MUST be ignored for trendlines of all other types.
numIntercept (8 bytes): A ChartNumNillable structure that specifies where the trendline intersects the value axis or vertical axis on bubble and scatter chart groups. If no intercept is specified, this ChartNumNillable structure MUST specify a NilChartNum structure, and the value of the type field in the NilChartNum structure MUST be 0x0100.
fEquation (1 byte): A Boolean (section 2.5.14) that specifies whether the trendline equation is displayed in the trendline label. MUST be ignored if regt is equal to 0x04. MUST be ignored if the chart sheet substream contains an attached label with an ObjectLink record that contains both a wLinkObj field equal to 0x0004 and a wLinkVar1 field equal to the zero-based index into a Series record in the collection of Series records in the current chart sheet substream that represents this trendline , and the attached label contains a SeriesText record.
fRSquared (1 byte): A Boolean that specifies whether the R-squared value is displayed in the trendline label. MUST be ignored if regt is equal to 0x04. MUST be ignored if the chart sheet substream contains an attached label with an ObjectLink record that contains both a wLinkObj field equal to 0x0004 and a wLinkVar1 field equal to the zero-based index into a Series record in the collection of Series records in the current chart sheet substream that represents this trendline, and the attached label contains a SeriesText record.
numForecast (8 bytes): An Xnum (section 2.5.342) that specifies the number of periods to forecast forward.
numBackcast (8 bytes): An Xnum that specifies the number of periods to forecast backward.