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: MasterHandoutSlide, BaseSlide, LayoutSlide, Slide, MasterSlide, NotesSlide, MasterNotesSlide
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. |
Returns: void
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. |
Returns: void
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. |
Returns: void
setFormat
| Name | Description |
|---|---|
| setFormat (Format) | Represents the format of the trend line. Read/write IFormat. |
Returns: void
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. |
Returns: void
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. |
Returns: void
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. |
Returns: void
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. |
Returns: void
setTrendlineName
| Name | Description |
|---|---|
| setTrendlineName (String) | Gets or sets name of the trendline. Read/write String. |
Returns: void
setTrendlineType
| Name | Description |
|---|---|
| setTrendlineType (int) | Gets or sets type of trend line. Read/write TrendlineType. |
Returns: void