Trendline

Trendline class

Class represents trend line of chart series

addTextFrameForOverriding

Name	Description
addTextFrameForOverriding (String)	Initialize TextFrameForOverriding with the text in paramener “text”. If TextFrameForOverriding is already initialized then simply changes its text.

Parameters:

Name	Type	Description
text	String	Text for a new TextFrameForOverriding.

Returns: TextFrame

---

getBackward

Name	Description
getBackward ()	Specifies the number of categories (or units on a scatter chart) that the trend line extends before the data for the series that is being trended. On scatter and non-scatter charts, the value shall be any nonnegative value. Read/write double.

Returns: double

---

getChart

Name	Description
getChart ()	Returns the parent chart. Read-only IChart.

Returns: Chart

---

getDisplayEquation

Name	Description
getDisplayEquation ()	Specifies that the equation for the trendline is displayed on the chart (in the same label as the Rsquaredvalue). Read/write boolean.

Returns: boolean

---

getDisplayRSquaredValue

Name	Description
getDisplayRSquaredValue ()	Specifies that the R-squared value of the trendline is displayed on the chart (in the same label as the equation). Read/write boolean.

Returns: boolean

---

getFormat

Name	Description
getFormat ()	Represents the format of the trend line. Read/write IFormat.

Returns: Format

---

getForward

Name	Description
getForward ()	Specifies the number of categories (or units on a scatter chart) that the trendline extends after the data for the series that is being trended. On scatter and non-scatter charts, the value shall be any non-negative value. Read/write double.

Returns: double

---

getIntercept

Name	Description
getIntercept ()	Specifies the value where the trendline shall cross the y axis. This property shall be supported only when the trendline type is exp, linear, or poly. Read/write double.

Returns: double

---

getOrder

Name	Description
getOrder ()	Specifies the order of the polynomial trend line. It is ignored for other trend line types. Value must be between 2 and 6. Read/write byte.

Returns: byte

---

getPeriod

Name	Description
getPeriod ()	Specifies the period of the trend line for a moving average trend line. It is ignored for other trend line variants. Value must be between 2 and 255. Read/write byte.

Returns: byte

---

getPresentation

Name	Description
getPresentation ()	Returns the parent presentation of a FillFormat. Read-only IPresentation.

Returns: Presentation

---

getRelatedLegendEntry

Name	Description
getRelatedLegendEntry ()	Represents legend entry related with this trendline Read-only ILegendEntryProperties.

Returns: LegendEntryProperties

---

getSlide

Name	Description
getSlide ()	Returns the parent slide of a FillFormat. Read-only BaseSlide.

Returns: Slide, MasterSlide, MasterNotesSlide, LayoutSlide, NotesSlide, BaseSlide, MasterHandoutSlide

---

getTextFormat

Name	Description
getTextFormat ()	Returns text format. Read-only IChartTextFormat.

Returns: ChartTextFormat

---

getTextFrameForOverriding

Name	Description
getTextFrameForOverriding ()	Can contain a rich formatted text. If this property is not null then this formatted text value overrides auto-generated text of data label. Auto-generated text of data label means text that is managed by ShowSeriesName, ShowValue, … properties and is formatted with the TextFormatManager.TextFormat property. Read-only ITextFrame.

Returns: TextFrame

---

getTrendlineName

Name	Description
getTrendlineName ()	Gets or sets name of the trendline. Read/write String.

Returns: String

---

getTrendlineType

Name	Description
getTrendlineType ()	Gets or sets type of trend line. Read/write TrendlineType.

Returns: int

---

setBackward

Name	Description
setBackward (double)	Specifies the number of categories (or units on a scatter chart) that the trend line extends before the data for the series that is being trended. On scatter and non-scatter charts, the value shall be any nonnegative value. Read/write double.

---

setDisplayEquation

Name	Description
setDisplayEquation (boolean)	Specifies that the equation for the trendline is displayed on the chart (in the same label as the Rsquaredvalue). Read/write boolean.

---

setDisplayRSquaredValue

Name	Description
setDisplayRSquaredValue (boolean)	Specifies that the R-squared value of the trendline is displayed on the chart (in the same label as the equation). Read/write boolean.

---

setFormat

Name	Description
setFormat (Format)	Represents the format of the trend line. Read/write IFormat.

---

setForward

Name	Description
setForward (double)	Specifies the number of categories (or units on a scatter chart) that the trendline extends after the data for the series that is being trended. On scatter and non-scatter charts, the value shall be any non-negative value. Read/write double.

---

setIntercept

Name	Description
setIntercept (double)	Specifies the value where the trendline shall cross the y axis. This property shall be supported only when the trendline type is exp, linear, or poly. Read/write double.

---

setOrder

Name	Description
setOrder (byte)	Specifies the order of the polynomial trend line. It is ignored for other trend line types. Value must be between 2 and 6. Read/write byte.

---

setPeriod

Name	Description
setPeriod (byte)	Specifies the period of the trend line for a moving average trend line. It is ignored for other trend line variants. Value must be between 2 and 255. Read/write byte.

---

setTrendlineName

Name	Description
setTrendlineName (String)	Gets or sets name of the trendline. Read/write String.

---

setTrendlineType

Name	Description
setTrendlineType (int)	Gets or sets type of trend line. Read/write TrendlineType.

---