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