Trendline Class

Trendline class

Represents a trendline in a chart.

type Trendline struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description
NewTrendline	Constructs from a parent object.

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
IsNameAuto	Returns if Microsoft Excel automatically determines the name of the trendline.
SetIsNameAuto	Returns if Microsoft Excel automatically determines the name of the trendline.
GetType	Returns the trendline type.
GetName	Returns the name of the trendline.
SetName	Returns the name of the trendline.
GetOrder	Returns or sets the trendline order (an integer greater than 1) when the trendline type is Polynomial.The order must be between 2 and 6.
SetOrder	Returns or sets the trendline order (an integer greater than 1) when the trendline type is Polynomial.The order must be between 2 and 6.
GetPeriod	Returns or sets the period for the moving-average trendline.
SetPeriod	Returns or sets the period for the moving-average trendline.
GetForward	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.The number of periods must be greater than or equal to zero.
SetForward	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.The number of periods must be greater than or equal to zero.
GetBackward	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward.The number of periods must be greater than or equal to zero.If the chart type is column ,the number of periods must be between 0 and 0.5
SetBackward	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward.The number of periods must be greater than or equal to zero.If the chart type is column ,the number of periods must be between 0 and 0.5
GetDisplayEquation	Represents if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Setting this property to True automatically turns on data labels.
SetDisplayEquation	Represents if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Setting this property to True automatically turns on data labels.
GetDisplayRSquared	Represents if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels.
SetDisplayRSquared	Represents if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels.
GetIntercept	Returns or sets the point where the trendline crosses the value axis.
SetIntercept	Returns or sets the point where the trendline crosses the value axis.
GetDataLabels	Represents the DataLabels object for the specified series.
GetLegendEntry	Gets the legend entry according to this trendline
GetCompoundType	Specifies the compound line type
SetCompoundType	Specifies the compound line type
GetDashType	Specifies the dash line type
SetDashType	Specifies the dash line type
GetCapType	Specifies the ending caps.
SetCapType	Specifies the ending caps.
GetJoinType	Specifies the joining caps.
SetJoinType	Specifies the joining caps.
GetBeginType	Specifies an arrowhead for the begin of a line.
SetBeginType	Specifies an arrowhead for the begin of a line.
GetEndType	Specifies an arrowhead for the end of a line.
SetEndType	Specifies an arrowhead for the end of a line.
GetBeginArrowLength	Specifies the length of the arrowhead for the begin of a line.
SetBeginArrowLength	Specifies the length of the arrowhead for the begin of a line.
GetEndArrowLength	Specifies the length of the arrowhead for the end of a line.
SetEndArrowLength	Specifies the length of the arrowhead for the end of a line.
GetBeginArrowWidth	Specifies the width of the arrowhead for the begin of a line.
SetBeginArrowWidth	Specifies the width of the arrowhead for the begin of a line.
GetEndArrowWidth	Specifies the width of the arrowhead for the end of a line.
SetEndArrowWidth	Specifies the width of the arrowhead for the end of a line.
GetThemeColor	Gets and sets the theme color.
SetThemeColor	Gets and sets the theme color.
GetColor	Represents the of the line.
SetColor	Represents the of the line.
GetTransparency	Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).
SetTransparency	Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).
GetStyle	Represents the style of the line.
SetStyle	Represents the style of the line.
GetWeight	Gets or sets the of the line.
SetWeight	Gets or sets the of the line.
GetWeightPt	Gets or sets the weight of the line in unit of points.
SetWeightPt	Gets or sets the weight of the line in unit of points.
GetWeightPx	Gets or sets the weight of the line in unit of pixels.
SetWeightPx	Gets or sets the weight of the line in unit of pixels.
GetFormattingType	Gets or sets format type.
SetFormattingType	Gets or sets format type.
IsAutomaticColor	Indicates whether the color of line is automatic assigned.
IsVisible	Represents whether the line is visible.
SetIsVisible	Represents whether the line is visible.
IsAuto	Indicates whether this line style is auto assigned.
SetIsAuto	Indicates whether this line style is auto assigned.
GetGradientFill	Represents gradient fill.