Excel.Interfaces.ChartTrendlineCollectionLoadOptions interface

表示图表趋势线的集合。Represents a collection of Chart Trendlines.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

属性

$all
backwardPeriod

对于集合中的每一项: 表示趋势线向后延伸的周期数。For EACH ITEM in the collection: Represents the number of periods that the trendline extends backward.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

format

对于集合中的每一项: 代表图表趋势线的格式。For EACH ITEM in the collection: Represents the formatting of a chart trendline.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

forwardPeriod

对于集合中的每一项: 表示趋势线向前延伸的周期数。For EACH ITEM in the collection: Represents the number of periods that the trendline extends forward.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

intercept

对于集合中的每一项: 代表趋势线的截距值。For EACH ITEM in the collection: Represents the intercept value of the trendline. 可以设置为数字值或空字符串(对于自动值)。Can be set to a numeric value or an empty string (for automatic values). 返回的值始终为数字。The returned value is always a number.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

label

对于集合中的每一项: 代表图表趋势线的标签。For EACH ITEM in the collection: Represents the label of a chart trendline.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

movingAveragePeriod

对于集合中的每一项: 代表图表趋势线的周期。For EACH ITEM in the collection: Represents the period of a chart trendline. 仅适用于 MovingAverage 类型的趋势线。Only applicable for trendline with MovingAverage type.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

name

对于集合中的每一项: 代表趋势线的名称。For EACH ITEM in the collection: Represents the name of the trendline. 可设为字符串值,或者设为 Null 值(表示自动值)。Can be set to a string value, or can be set to null value represents automatic values. 返回的值始终为字符串The returned value is always a string

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

polynomialOrder

对于集合中的每一项: 表示图表趋势线的顺序。For EACH ITEM in the collection: Represents the order of a chart trendline. 仅适用于具有多项式类型的趋势线。Only applicable for trendline with Polynomial type.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showEquation

对于集合中的每个项目: 如果图表上显示趋势线的公式, 则为 True。For EACH ITEM in the collection: True if the equation for the trendline is displayed on the chart.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showRSquared

对于集合中的每一项: 如果趋势线的 R 平方值显示在图表上, 则为 True。For EACH ITEM in the collection: True if the R-squared for the trendline is displayed on the chart.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

type

对于集合中的每一项: 代表图表趋势线的类型。For EACH ITEM in the collection: Represents the type of a chart trendline.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

backwardPeriod

对于集合中的每一项: 表示趋势线向后延伸的周期数。For EACH ITEM in the collection: Represents the number of periods that the trendline extends backward.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

backwardPeriod?: boolean;

属性值

boolean

format

对于集合中的每一项: 代表图表趋势线的格式。For EACH ITEM in the collection: Represents the formatting of a chart trendline.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

format?: Excel.Interfaces.ChartTrendlineFormatLoadOptions;

属性值

forwardPeriod

对于集合中的每一项: 表示趋势线向前延伸的周期数。For EACH ITEM in the collection: Represents the number of periods that the trendline extends forward.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

forwardPeriod?: boolean;

属性值

boolean

intercept

对于集合中的每一项: 代表趋势线的截距值。For EACH ITEM in the collection: Represents the intercept value of the trendline. 可以设置为数字值或空字符串(对于自动值)。Can be set to a numeric value or an empty string (for automatic values). 返回的值始终为数字。The returned value is always a number.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

intercept?: boolean;

属性值

boolean

label

对于集合中的每一项: 代表图表趋势线的标签。For EACH ITEM in the collection: Represents the label of a chart trendline.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

label?: Excel.Interfaces.ChartTrendlineLabelLoadOptions;

属性值

movingAveragePeriod

对于集合中的每一项: 代表图表趋势线的周期。For EACH ITEM in the collection: Represents the period of a chart trendline. 仅适用于 MovingAverage 类型的趋势线。Only applicable for trendline with MovingAverage type.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

movingAveragePeriod?: boolean;

属性值

boolean

name

对于集合中的每一项: 代表趋势线的名称。For EACH ITEM in the collection: Represents the name of the trendline. 可设为字符串值,或者设为 Null 值(表示自动值)。Can be set to a string value, or can be set to null value represents automatic values. 返回的值始终为字符串The returned value is always a string

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

name?: boolean;

属性值

boolean

polynomialOrder

对于集合中的每一项: 表示图表趋势线的顺序。For EACH ITEM in the collection: Represents the order of a chart trendline. 仅适用于具有多项式类型的趋势线。Only applicable for trendline with Polynomial type.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

polynomialOrder?: boolean;

属性值

boolean

showEquation

对于集合中的每个项目: 如果图表上显示趋势线的公式, 则为 True。For EACH ITEM in the collection: True if the equation for the trendline is displayed on the chart.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showEquation?: boolean;

属性值

boolean

showRSquared

对于集合中的每一项: 如果趋势线的 R 平方值显示在图表上, 则为 True。For EACH ITEM in the collection: True if the R-squared for the trendline is displayed on the chart.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showRSquared?: boolean;

属性值

boolean

type

对于集合中的每一项: 代表图表趋势线的类型。For EACH ITEM in the collection: Represents the type of a chart trendline.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

type?: boolean;

属性值

boolean