alexa
menu

MAUI

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

    Show / Hide Table of Contents

    Interface IChartSerie

    Represents a series in the chart.

    Inherited Members
    IParentApplication.Application
    IParentApplication.Parent
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public interface IChartSerie : IParentApplication

    Properties

    Bubbles

    Gets or sets series values of the bubble chart.

    Declaration
    IRange Bubbles { get; set; }
    Property Value
    Type
    IRange
    Examples

    For bubble chart both horizontal and vertical axes are value axes so for the first value axis we set serie value to Values property and the next value axis we make use of Bubbles property.

    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"].Value = "50";
        sheet.Range["B1"].Value = "60";
        sheet.Range["C1"].Value = "5";
        sheet.Range["A2"].Value = "1";
        sheet.Range["B2"].Value = "4";
        sheet.Range["C2"].Value = "2";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set serie
        IChartSerie serie = chart.Series.Add(ExcelChartType.Bubble);
    
        //Set values
        serie.Values = sheet.Range["A1:C1"];
    
        //Set bubble chart range
        serie.Bubbles = sheet.Range["A2:C2"];
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    CategoryLabels

    Gets or sets category labels for the series.

    Declaration
    IRange CategoryLabels { get; set; }
    Property Value
    Type
    IRange
    Examples

    The following code illustrates how to set category labels for IChartSerie in charts.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set serie
        IChartSerie serie = chart.Series.Add();
    
        //Set category labels and values
        serie.CategoryLabels = sheet.Range["A1:C1"];
        serie.Values = sheet.Range["A2:C2"];
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    DataPoints

    Gets the IChartDataPoints collection in the series. Read-only.

    Declaration
    IChartDataPoints DataPoints { get; }
    Property Value
    Type
    IChartDataPoints
    Examples

    The following code illustrates how to access the IChartDataPoints collection from IChartSerie.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set data points
        IChartDataPoints dataPoints = chart.Series[0].DataPoints;
    
        //Set data labels value visibility             
        dataPoints.DefaultDataPoint.DataLabels.IsValue = true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    EnteredDirectlyBubbles

    Gets or sets the directly entered series values for Bubble chart.

    Declaration
    object[] EnteredDirectlyBubbles { get; set; }
    Property Value
    Type
    object[]
    Examples

    The following code illustrates how series data for second value axis of Bubble charts can be directly given for charts.

    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];
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set serie
        IChartSerie serie = chart.Series.Add(ExcelChartType.Bubble);
    
        //Set direct values
        serie.EnteredDirectlyValues = new object[] { 10, 20, 30 };
    
        //Set bubble chart direct values
        serie.EnteredDirectlyBubbles = new object[] { 1, 4, 2 };
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    EnteredDirectlyCategoryLabels

    Gets or sets the directly entered category values.

    Declaration
    object[] EnteredDirectlyCategoryLabels { get; set; }
    Property Value
    Type
    object[]
    Examples
    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];
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set serie
        IChartSerie serie = chart.Series.Add(ExcelChartType.Pie);
    
        //Set direct values
        serie.EnteredDirectlyValues = new object[] { 2000, 1000, 1000 };
    
        //Set direct category label
        serie.EnteredDirectlyCategoryLabels = new object[] { "Total Income", "Expenses", "Profit" };
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    EnteredDirectlyValues

    Gets or sets the directly entered series values.

    Declaration
    object[] EnteredDirectlyValues { get; set; }
    Property Value
    Type
    object[]
    Examples
    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];
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set serie
        IChartSerie serie = chart.Series.Add(ExcelChartType.Pie);
    
        //Set direct values
        serie.EnteredDirectlyValues = new object[] { 2000, 1000, 1000 };
    
        //Set direct category label
        serie.EnteredDirectlyCategoryLabels = new object[] { "Total Income", "Expenses", "Profit" };
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ErrorBarsX

    Gets the error bars on the X-axis. Read-only.

    Declaration
    IChartErrorBars ErrorBarsX { get; }
    Property Value
    Type
    IChartErrorBars
    Examples

    The following code illustrates how IChartErrorBars in X-axis can be accessed.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set chart type
        chart.ChartType = ExcelChartType.Scatter_Line;
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].HasErrorBarsX = true;
        IChartErrorBars errorBar = chart.Series[0].ErrorBarsX;
    
        //Set error bar type
        errorBar.Type = ExcelErrorBarType.Percentage;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ErrorBarsY

    Gets the error bars on Y-axis. Read-only.

    Declaration
    IChartErrorBars ErrorBarsY { get; }
    Property Value
    Type
    IChartErrorBars
    Examples

    The following code illustrates how IChartErrorBars on Y-axis can be accessed.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set chart type
        chart.ChartType = ExcelChartType.Scatter_Line;
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].HasErrorBarsY = true;
        IChartErrorBars errorBar = chart.Series[0].ErrorBarsY;
    
        //Set error bar type
        errorBar.Type = ExcelErrorBarType.Percentage;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    HasErrorBarsX

    True if series contains X error bars. otherwise False.

    Declaration
    bool HasErrorBarsX { get; set; }
    Property Value
    Type
    bool
    Examples

    The following code illustrates how HasErrorBarsX property can be used.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set chart type
        chart.ChartType = ExcelChartType.Scatter_Line;
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].HasErrorBarsX = true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    HasErrorBarsY

    True if series contains Y error bars. otherwise False.

    Declaration
    bool HasErrorBarsY { get; set; }
    Property Value
    Type
    bool
    Examples
    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set chart type
        chart.ChartType = ExcelChartType.Scatter_Line;
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].HasErrorBarsY = true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    HasLeaderLines

    Declaration
    bool HasLeaderLines { get; set; }
    Property Value
    Type
    bool

    InvertIfNegative

    Gets or sets a value to specify the series to invert its colors if the value is negative. The default value is true.

    Declaration
    bool? InvertIfNegative { get; set; }
    Property Value
    Type
    bool?
    Examples
    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set chart type
        chart.Series[0].SerieType = ExcelChartType.Column_Cluster;
        chart.Series[0].InvertIfNegative =true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    InvertIfNegativeColor

    Gets or sets a value to specify the series to invert its colors if the value is negative.

    Declaration
    ColorObject InvertIfNegativeColor { get; set; }
    Property Value
    Type
    ColorObject
    Examples

    The following code illustrates how to set values for IChartSerie in charts.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set chart type
        chart.Series[0].SerieType = ExcelChartType.Column_Cluster;
        chart.Series[0].InvertIfNegative =true;
        chart.Series[0].InvertIfNegativeColor= Color.Red;
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    IsFiltered

    Gets or sets a boolean value indicating whether the series has been filtered out from the chart.

    Declaration
    bool IsFiltered { get; set; }
    Property Value
    Type
    bool
    Examples

    By default all the series in the chart are shown because IsFiltered property is set to "false". Here for example, we set first serie IsFiltered property to "true" so it is filtered out from the chart and it will not be shown in the chart.

    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"].Text = "Apr";
        sheet.Range["B2"].Text = "May";
        sheet.Range["C2"].Text = "Jun";
    
        sheet.Range["A4"].Value = "10";
        sheet.Range["B4"].Value = "20";
        sheet.Range["C4"].Value = "30";
        sheet.Range["A3"].Value = "15";
        sheet.Range["B3"].Value = "10";
        sheet.Range["C3"].Value = "35";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C4"];
    
        //Set chart type
        chart.ChartType = ExcelChartType.Line;
    
        //Set IsFiltered
        chart.Series[0].IsFiltered = true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    LeaderLines

    Declaration
    IChartBorder LeaderLines { get; }
    Property Value
    Type
    IChartBorder

    Name

    Gets or sets the name of the series.

    Declaration
    string Name { get; set; }
    Property Value
    Type
    string
    Examples

    The following code illustrates how to access the name of the IChartSerie.

            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";
    
                //Create chart
                IChart chart = sheet.Charts.Add();
    
                //Set serie
                IChartSerie serie = chart.Series.Add("BarSerie");
    
                //Set category labels and values
                serie.CategoryLabels = sheet.Range["A1:C1"];
                serie.Values = sheet.Range["A2:C2"];
    
                //Get Serie name
                Console.Write(serie.Name);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();
            }
    //Output will be
    //BarSerie

    NameRange

    Gets or sets the series name range.

    Declaration
    IRange NameRange { get; }
    Property Value
    Type
    IRange
    Examples

    The following code illustrates how to access the name range of a particular IChartSerie in the IChartSeries 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 = "Width";
                sheet.Range["A2"].Text = "Height";
                sheet.Range["B1"].Value = "50";
                sheet.Range["C1"].Value = "60";
                sheet.Range["D1"].Value = "5";
                sheet.Range["B2"].Value = "1";
                sheet.Range["C2"].Value = "4";
                sheet.Range["D2"].Value = "2";
    
                //Create chart
                IChart chart = sheet.Charts.Add();
    
                //Set chart type
                chart.ChartType = ExcelChartType.Bubble;
    
                //Set range
                chart.DataRange = sheet["A1:D2"];
    
                //Get name range
                Console.Write(chart.Series[0].NameRange.AddressLocal);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();
            }
    //Output will be
    //A1

    ParetoLineFormat

    Gets the Pareto line on the Pareto charts. Read-only.

    Declaration
    IChartFrameFormat ParetoLineFormat { get; }
    Property Value
    Type
    IChartFrameFormat
    Examples

    The following code illustrates how to set pareto line properties of the Pareto chart.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set chart format
        chart.ChartType = ExcelChartType.Pareto;
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set pareto line format
        IChartFrameFormat format = chart.Series[0].ParetoLineFormat;
        format.LineProperties.ColorIndex = ExcelKnownColors.Red;
    
        //Save the workbook
        MemoryStream stream = new MemoryStream();
        workbook.SaveAs(stream);
    }

    SerieFormat

    Gets or sets the IChartSerieDataFormat of the series.

    Declaration
    IChartSerieDataFormat SerieFormat { get; }
    Property Value
    Type
    IChartSerieDataFormat
    Examples

    The following code illustrates how to access the IChartSerieDataFormat from IChartSerie.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set chart type
        chart.ChartType = ExcelChartType.Line;
    
        //Set serie format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set marker style
        format.MarkerStyle = ExcelChartMarkerType.Star;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    SerieType

    Gets or sets the series type.

    Declaration
    ExcelChartType SerieType { get; set; }
    Property Value
    Type
    ExcelChartType
    Examples

    SerieType property can be used to create a combination chart by adding more series to the charts. Here for example, we create a chart. By default the ChartType will be Column_Clustered, here we change it by setting SerieType to Line.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set chart type
        chart.Series[0].SerieType = ExcelChartType.Line;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    TrendLines

    Gets the IChartTrendLines collection of the series. Read-only.

    Declaration
    IChartTrendLines TrendLines { get; }
    Property Value
    Type
    IChartTrendLines
    Examples

    The following code illustrates how IChartTrendLines collection can be accessed from a particular IChartSerie.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set trend line
        IChartTrendLines trendLines = chart.Series[0].TrendLines;
        IChartTrendLine trendLine = trendLines.Add(ExcelTrendLineType.Linear);
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    UsePrimaryAxis

    Gets or sets a boolean value indicating whether to use primary axis for series drawing. False to use secondary axis.

    Declaration
    bool UsePrimaryAxis { get; set; }
    Property Value
    Type
    bool
    Examples

    The following code illustrates how the secondary axis can be used by disabling primary axis.

    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 = "100";
        sheet.Range["B3"].Value = "200";
        sheet.Range["C3"].Value = "300";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C3"];
    
        //Set secondary axis
        IChartSerie serie = chart.Series[1];
        serie.UsePrimaryAxis = false;
        chart.SecondaryCategoryAxis.Visible = true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    Values

    Gets or sets the series values.

    Declaration
    IRange Values { get; set; }
    Property Value
    Type
    IRange
    Examples

    The following code illustrates how to set values for IChartSerie in charts.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set serie
        IChartSerie serie = chart.Series.Add();
    
        //Set category labels and values
        serie.CategoryLabels = sheet.Range["A1:C1"];
        serie.Values = sheet.Range["A2:C2"];
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    Methods

    ErrorBar(bool)

    Creates IChartErrorBars in the specified axis.

    Declaration
    IChartErrorBars ErrorBar(bool bIsY)
    Parameters
    Type Name Description
    bool bIsY

    If true - on Y axis; otherwise on X axis.

    Returns
    Type Description
    IChartErrorBars

    IChartErrorBars for the IChartSerie.

    Examples

    The following code illustrates how to set IChartErrorBars on Y-axis of a particular IChartSerie.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].ErrorBar(true);
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ErrorBar(bool, ExcelErrorBarInclude)

    Creates IChartErrorBars in the specified axis with specified ExcelErrorBarInclude type.

    Declaration
    IChartErrorBars ErrorBar(bool bIsY, ExcelErrorBarInclude include)
    Parameters
    Type Name Description
    bool bIsY

    If true - on Y axis; otherwise on X axis.

    ExcelErrorBarInclude include

    Represents ExcelErrorBarInclude type.

    Returns
    Type Description
    IChartErrorBars

    IChartErrorBars for the IChartSerie.

    Examples

    The following code illustrates how to set IChartErrorBars with Plus on Y-axis of a particular IChartSerie.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].ErrorBar(true, ExcelErrorBarInclude.Plus);
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ErrorBar(bool, ExcelErrorBarInclude, ExcelErrorBarType)

    Creates IChartErrorBars of specified ExcelErrorBarType.

    Declaration
    IChartErrorBars ErrorBar(bool bIsY, ExcelErrorBarInclude include, ExcelErrorBarType type)
    Parameters
    Type Name Description
    bool bIsY

    If true - on Y axis; otherwise on X axis.

    ExcelErrorBarInclude include

    Represents ExcelErrorBarInclude type.

    ExcelErrorBarType type

    Represents ExcelErrorBarType.

    Returns
    Type Description
    IChartErrorBars

    IChartErrorBars for the IChartSerie.

    Examples

    The following code illustrates how to set IChartErrorBars with Plus and Percentage on Y-axis of a particular IChartSerie.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].ErrorBar(true, ExcelErrorBarInclude.Plus, ExcelErrorBarType.Percentage);
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ErrorBar(bool, ExcelErrorBarInclude, ExcelErrorBarType, double)

    Creates IChartErrorBars of specified ExcelErrorBarType with the specified number value.

    Declaration
    IChartErrorBars ErrorBar(bool bIsY, ExcelErrorBarInclude include, ExcelErrorBarType type, double numberValue)
    Parameters
    Type Name Description
    bool bIsY

    If true - on Y axis; otherwise on X axis.

    ExcelErrorBarInclude include

    Represents ExcelErrorBarInclude type.

    ExcelErrorBarType type

    Represents ExcelErrorBarType.

    double numberValue

    Represents number value for the applicable ExcelErrorBarType.

    Returns
    Type Description
    IChartErrorBars

    IChartErrorBars for the IChartSerie.

    Remarks

    The number value is applicable for Percentage, Fixed and StandardDeviation error bar types.

    Examples

    The following code illustrates how to set IChartErrorBars with Plus , Percentage and number value of "50" on Y-axis of a particular IChartSerie.

    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";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].ErrorBar(true, ExcelErrorBarInclude.Plus, ExcelErrorBarType.Percentage, 50);
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ErrorBar(bool, IRange, IRange)

    Creates custom IChartErrorBars type.

    Declaration
    IChartErrorBars ErrorBar(bool bIsY, IRange plusRange, IRange minusRange)
    Parameters
    Type Name Description
    bool bIsY

    If true - on Y axis; otherwise on X axis.

    IRange plusRange

    Represents PlusRange.

    IRange minusRange

    Represents MinusRange.

    Returns
    Type Description
    IChartErrorBars

    IChartErrorBars for the IChartSerie.

    Examples

    The following code illustrates how an IChartErrorBars can be created on X-axis with PlusRange and MinusRange.

    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 = "1";
        sheet.Range["B3"].Value = "1";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set chart type
        chart.ChartType = ExcelChartType.Scatter_Line;
    
        //Set range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set error bar
        chart.Series[0].ErrorBar(false, sheet.Range["A3"], sheet.Range["B3"]);
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved