alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Interface IChartTrendLines

    Interface that represents trend line collection.

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public interface IChartTrendLines

    Properties

    Count

    Returns the number of IChartTrendLine in the IChartTrendLines collection. Read-only

    Declaration
    int Count { get; }
    Property Value
    Type
    int
    Examples

    The following code illustrates how to get the number of IChartTrendLine in the IChartTrendLines collection.

            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 trendlines
                IChartTrendLine trendLine1 = trendLines.Add(ExcelTrendLineType.Logarithmic);
                IChartTrendLine trendLine2 = trendLines.Add(ExcelTrendLineType.Linear);
    
                Console.WriteLine("Number of TrendLines created is: " + trendLines.Count);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();        
            }
    //Output will be
    //Number of TrendLines created is: 2

    this[int]

    Gets single trend line by index. Read-only.

    Declaration
    IChartTrendLine this[int iIndex] { get; }
    Parameters
    Type Name Description
    int iIndex
    Property Value
    Type
    IChartTrendLine
    Examples

    The following code illustrates how to access IChartTrendLine from the IChartTrendLines collection.

    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 trendlines
        trendLines.Add(ExcelTrendLineType.Logarithmic);
        trendLines.Add(ExcelTrendLineType.Linear);
    
        //Accessing the first trendline from collection
        IChartTrendLine trendline = trendLines[0];
    
        //Set trendline Name
        trendline.Name = "TrendLine 1";
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    Methods

    Add()

    Adds a new IChartTrendLine to IChartTrendLines collection and Returns it.

    Declaration
    IChartTrendLine Add()
    Returns
    Type Description
    IChartTrendLine

    Returns added trend line object.

    Examples

    The following code illustrates how to access and add new instance of IChartTrendLine to IChartTrendLines

    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
        IChartTrendLine trendLine = trendLines.Add();
    
        //Set trendline name
        trendLine.Name = "trendline";
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    Add(ExcelTrendLineType)

    Adds a new IChartTrendLine with specified ExcelTrendLineType to IChartTrendLines collection and Returns it.

    Declaration
    IChartTrendLine Add(ExcelTrendLineType type)
    Parameters
    Type Name Description
    ExcelTrendLineType type

    Represents type of trend line.

    Returns
    Type Description
    IChartTrendLine

    Returns added trend line object.

    Examples

    The following code illustrates how to access and add new instance of IChartTrendLine with specified ExcelTrendLineType to IChartTrendLines

    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();
    }

    Clear()

    Clears current IChartTrendLines collection.

    Declaration
    void Clear()
    Examples

    The following code illustrates how to clear IChartTrendLines collection

            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 trendlines
                IChartTrendLine trendLine1 = trendLines.Add(ExcelTrendLineType.Logarithmic);
                IChartTrendLine trendLine2 = trendLines.Add(ExcelTrendLineType.Linear);
    
                Console.WriteLine("Before TrendLines Count is: " + trendLines.Count);
    
                //Clears the trendlines collection
                trendLines.Clear();
    
                Console.WriteLine("After TrendLines Count is: " + trendLines.Count);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();        
            }
    //Output will be
    //Before TrendLines Count is: 2
    //After TrendLines Count is: 0

    RemoveAt(int)

    Removes a IChartTrendLine from IChartTrendLines collection.

    Declaration
    void RemoveAt(int index)
    Parameters
    Type Name Description
    int index

    Index of the IChartTrendLine to remove.

    Examples

    The following code illustrates how to remove IChartTrendLine by index from IChartTrendLines

            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 trendlines
                IChartTrendLine trendLine1 = trendLines.Add(ExcelTrendLineType.Logarithmic);
                IChartTrendLine trendLine2 = trendLines.Add(ExcelTrendLineType.Linear);
    
                Console.WriteLine("Before TrendLines Count is: " + trendLines.Count);
    
                //Remove the trendline from the collection
                trendLines.RemoveAt(0);
    
                Console.WriteLine("After TrendLines Count is: " + trendLines.Count);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();        
            }
    //Output will be
    //Before TrendLines Count is: 2
    //After TrendLines Count is: 1
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved