Excel.Interfaces.ChartTrendlineUpdateData interface

一个用于更新 ChartTrendline 对象上的数据的接口, 可用于 "ChartTrendline (An interface for updating data on the ChartTrendline object, for use in "chartTrendline.set({ ... })".

属性

backwardPeriod

表示趋势线向后延伸的周期数。Represents the number of periods that the trendline extends backward.

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

format

表示图表趋势线的格式。Represents the formatting of a chart trendline.

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

forwardPeriod

表示趋势线向前延伸的周期数。Represents the number of periods that the trendline extends forward.

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

intercept

表示趋势线的截距值。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

表示图表趋势线的标签。Represents the label of a chart trendline.

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

movingAveragePeriod

表示图表趋势线的周期。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

表示趋势线的名称。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

表示图表趋势线的顺序。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。True if the equation for the trendline is displayed on the chart.

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

showRSquared

如果图表上显示趋势线的 R 平方值,则为 True。True if the R-squared for the trendline is displayed on the chart.

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

type

表示图表趋势线的类型。Represents the type of a chart trendline.

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

属性详细信息

backwardPeriod

表示趋势线向后延伸的周期数。Represents the number of periods that the trendline extends backward.

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

backwardPeriod?: number;

属性值

number

format

表示图表趋势线的格式。Represents the formatting of a chart trendline.

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

format?: Excel.Interfaces.ChartTrendlineFormatUpdateData;

属性值

forwardPeriod

表示趋势线向前延伸的周期数。Represents the number of periods that the trendline extends forward.

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

forwardPeriod?: number;

属性值

number

intercept

表示趋势线的截距值。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?: any;

属性值

any

label

表示图表趋势线的标签。Represents the label of a chart trendline.

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

label?: Excel.Interfaces.ChartTrendlineLabelUpdateData;

属性值

movingAveragePeriod

表示图表趋势线的周期。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?: number;

属性值

number

name

表示趋势线的名称。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?: string;

属性值

string

polynomialOrder

表示图表趋势线的顺序。Represents the order of a chart trendline. 仅适用于具有多项式类型的趋势线。Only applicable for trendline with Polynomial type.

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

polynomialOrder?: number;

属性值

number

showEquation

如果图表上显示趋势线公式,则为 True。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。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

表示图表趋势线的类型。Represents the type of a chart trendline.

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

type?: Excel.ChartTrendlineType | "Linear" | "Exponential" | "Logarithmic" | "MovingAverage" | "Polynomial" | "Power";

属性值

Excel.ChartTrendlineType | "Linear" | "Exponential" | "Logarithmic" | "MovingAverage" | "Polynomial" | "Power"