TrendlineCollection
Contents
[
Hide
]TrendlineCollection class
Represents a collection of all the Trendline objects for the specified data series.
class TrendlineCollection;
Example
const { Workbook, ChartType, TrendlineType, Color } = AsposeCells;
var excel = new Workbook();
var chartIndex = excel.worksheets.get(0).charts.add(ChartType.Column, 3, 3, 15, 10);
var chart = excel.worksheets.get(0).charts.get(chartIndex);
chart.nSeries.add("A1:a3", true);
chart.nSeries.get(0).trendLines.add(TrendlineType.Linear, "MyTrendLine");
var line = chart.nSeries.get(0).trendLines.get(0);
line.displayEquation = true;
line.displayRSquared = true;
line.color = Color.Red;
Methods
| Method | Description |
|---|---|
| get(number) | Gets a Trendline object by its index. |
| add(TrendlineType) | Adds a Trendline object to this collection with specified type. |
| add(TrendlineType, string) | Adds a Trendline object to this collection with specified type and name. |
get(number)
Gets a Trendline object by its index.
get(index: number) : Trendline;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number |
Returns
add(TrendlineType)
Adds a Trendline object to this collection with specified type.
add(type: TrendlineType) : number;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| type | TrendlineType | Trendline type. |
Returns
Trendline object index.
add(TrendlineType, string)
Adds a Trendline object to this collection with specified type and name.
add(type: TrendlineType, name: string) : number;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| type | TrendlineType | Trendline type. |
| name | string | Trendline name. |
Returns
Trendline object index.