Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.4.250 SerAuxTrend

Office

The SerAuxTrend record specifies a trendline.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

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

Moving average

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.

Show:
© 2015 Microsoft