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
| 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, LayoutSlide, MasterHandoutSlide, NotesSlide, BaseSlide, 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. |
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. |
| 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. |