Syncfusion.XlsIO.Base
Example 


Represents type of trend line.

Add(ExcelTrendLineType) Method

Adds a new IChartTrendLine with specified ExcelTrendLineType to IChartTrendLines collection and Returns it.
Syntax
'Declaration
 
Overloads Function Add( _
   ByVal type As ExcelTrendLineType _
) As IChartTrendLine
'Usage
 
Dim instance As IChartTrendLines
Dim type As ExcelTrendLineType
Dim value As IChartTrendLine
 
value = instance.Add(type)

Parameters

type
Represents type of trend line.

Return Value

Returns added trend line object.
Example
The following code illustrates how to access and add new instance of IChartTrendLine with specified ExcelTrendLineType to IChartTrendLines
using Syncfusion.XlsIO;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            sheet.Range["A3"].Value = "15";
            sheet.Range["B3"].Value = "25";
            sheet.Range["C3"].Value = "35";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C3"];
            
            //Set chart type
            chart.ChartType = ExcelChartType.Column_Clustered;
            
            //Get chart serie
            IChartSerie serie = chart.Series[0];
            
            //Get chart serie trendlines collection
            IChartTrendLines trendLines = serie.TrendLines;
            
            //Add new trendline instance with logarithmic type
            IChartTrendLine trendLine = trendLines.Add(ExcelTrendLineType.Logarithmic);
            
            //Set trendline name
            trendLine.Name = "trendline";
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.38

See Also