GrapeCity.Documents.Excel.Drawing.ITrendlines.Add

Add Method

Add()

Creates a new trendline and adds it to this collection.

Use this method to create a trendline for the parent series and then configure the returned ITrendline object.

Declaration

ITrendline Add()

Function Add() As ITrendline

Returns

Type	Description
ITrendline	The created ITrendline object.

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 10},
    {"Feb", 12},
    {"Mar", 15}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, false);
ITrendline trendline = chart.SeriesCollection[0].Trendlines.Add();
trendline.Type = TrendlineType.Linear;