Trendline

Trendline class

Class represents trend line of chart series

addTextFrameForOverriding

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

Parameters:

NameTypeDescription
textStringText for a new TextFrameForOverriding.

Returns: TextFrame


getBackward

NameDescription
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

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

Returns: Chart


getDisplayEquation

NameDescription
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

NameDescription
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

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

Returns: Format


getForward

NameDescription
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

NameDescription
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

NameDescription
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

NameDescription
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

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

Returns: Presentation


getRelatedLegendEntry

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

Returns: LegendEntryProperties


getSlide

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

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


getTextFormat

NameDescription
getTextFormat ()Returns text format. Read-only IChartTextFormat.

Returns: ChartTextFormat


getTextFrameForOverriding

NameDescription
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

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

Returns: String


getTrendlineType

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

Returns: int


setBackward

NameDescription
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.

Returns: void


setDisplayEquation

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

Returns: void


setDisplayRSquaredValue

NameDescription
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.

Returns: void


setFormat

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

Returns: void


setForward

NameDescription
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.

Returns: void


setIntercept

NameDescription
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.

Returns: void


setOrder

NameDescription
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.

Returns: void


setPeriod

NameDescription
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.

Returns: void


setTrendlineName

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

Returns: void


setTrendlineType

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

Returns: void