alexa
menu

MAUI

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

    Show / Hide Table of Contents

    Interface IChartSerieDataFormat

    Represents formatting options for the series data.

    Inherited Members
    IChartFillBorder.Fill
    IChartFillBorder.Has3dProperties
    IChartFillBorder.HasInterior
    IChartFillBorder.HasLineProperties
    IChartFillBorder.HasShadowProperties
    IChartFillBorder.Interior
    IChartFillBorder.LineProperties
    IChartFillBorder.Shadow
    IChartFillBorder.ThreeD
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public interface IChartSerieDataFormat : IChartFillBorder

    Properties

    AreaProperties

    Gets the area properties of the chart. Read-only.

    Declaration
    IChartInterior AreaProperties { get; }
    Property Value
    Type
    IChartInterior
    Examples

    The following code illustrates how to access AreaProperties properties and set color to ForegroundColorIndex 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"].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 interior
        IChartInterior interior = chart.Series[0].SerieFormat.AreaProperties;
    
        //Set color
        interior.ForegroundColorIndex = ExcelKnownColors.Red;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    BarShapeBase

    Gets or sets the base shape used with the 3-D bar or column chart.

    Declaration
    ExcelBaseFormat BarShapeBase { get; set; }
    Property Value
    Type
    ExcelBaseFormat
    Examples

    By default BarShapeBase is set to Rectangle. Here for example, we set Circle to BarShapeBase.

    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.Bar_Stacked_3D;
    
        //Set Bar shape base
        chart.Series[0].SerieFormat.BarShapeBase = ExcelBaseFormat.Circle;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    BarShapeTop

    Represents the top shape used with the 3-D bar or column chart.

    Declaration
    ExcelTopFormat BarShapeTop { get; set; }
    Property Value
    Type
    ExcelTopFormat
    Examples

    By default BarShapeTop is set to Straight. Here for example, we set Sharp to BarShapeTop 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"].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.Bar_Stacked_3D;
    
        //Set Bar shape base
        chart.Series[0].SerieFormat.BarShapeTop = ExcelTopFormat.Sharp;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    CommonSerieOptions

    Gets the common series options. Read-only.

    Declaration
    IChartFormat CommonSerieOptions { get; }
    Property Value
    Type
    IChartFormat
    Examples

    The following code illustrates how GapWidth can be set by accessing CommonSerieOptions 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"].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.Column_Stacked_3D;
    
        //Set common serie options
        IChartFormat commonSerieOptions = chart.Series[0].SerieFormat.CommonSerieOptions;
    
        //Set Gap width
        commonSerieOptions.GapWidth = 400;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    Is3DBubbles

    True to draw bubbles with 3D effects. otherwise False.

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

    The following code illustrates how Is3DBubbles 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"].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 range
                chart.DataRange = sheet.Range["A1:C2"];
    
                //Set chart type
                chart.ChartType = ExcelChartType.Bubble_3D;
    
                //Set serie format
                IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
                //Check type
                Console.WriteLine(format.Is3DBubbles);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();
            }
    //Output will be
    //True

    IsAutoMarker

    True if the series has auto marker. otherwise False.

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

    The following code illustrates how IsAutoMarker 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["D1"].Text = "Apr";
                sheet.Range["E1"].Text = "May";
                sheet.Range["F1"].Text = "Jun";
                sheet.Range["A2"].Value = "5";
                sheet.Range["B2"].Value = "21";
                sheet.Range["C2"].Value = "15";
                sheet.Range["D2"].Value = "12";
                sheet.Range["E2"].Value = "28";
                sheet.Range["F2"].Value = "9";
    
                //Create chart
                IChart chart = sheet.Charts.Add();
    
                //Set range
                chart.DataRange = sheet.Range["A1:F2"];
    
                //Set chart type
                chart.ChartType = ExcelChartType.Line_Markers;
    
                //Set serie data format
                IChartSerieDataFormat format = chart.Series[0].DataPoints.DefaultDataPoint.DataFormat;
    
                //Check auto marker
                Console.Write(format.IsAutoMarker);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();
            }
    //Output will be
    //True

    IsMarkerSupported

    True if the marker is supported by this chart/series. otherwise False. Read-only.

    Declaration
    bool IsMarkerSupported { get; }
    Property Value
    Type
    bool
    Examples

    The following code illustrates how to access the IsMarkerSupported 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"].Text = "Jan";
                sheet.Range["B1"].Text = "Feb";
                sheet.Range["C1"].Text = "Mar";
                sheet.Range["A2"].Value = "50";
                sheet.Range["B2"].Value = "60";
                sheet.Range["C2"].Value = "5";
    
                //Create chart
                IChart chart = sheet.Charts.Add();
    
                //Set range
                chart.DataRange = sheet.Range["A1:C2"];
    
                //Set chart type
                chart.ChartType = ExcelChartType.Pie;
    
                //Set serie format
                IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
                //Check marker support
                Console.WriteLine(format.IsMarkerSupported);
    
                //Save and Dispose
                workbook.SaveAs("Chart.xlsx");
                workbook.Close();
                Console.ReadKey();
            }
    //Output will be
    //False

    MarkerBackgroundColor

    Gets or sets the marker fill color.

    Declaration
    Color MarkerBackgroundColor { get; set; }
    Property Value
    Type
    Color
    Examples

    The following code illustrates how to set color to markers 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.ChartType = ExcelChartType.Line;
    
        //Set serie format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set marker style
        format.MarkerStyle = ExcelChartMarkerType.Circle;
    
        //Set color
        format.MarkerBackgroundColor = System.Drawing.Color.Red;
        format.MarkerForegroundColor = System.Drawing.Color.Black;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    MarkerBackgroundColorIndex

    Gets or sets the index of marker fill color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors MarkerBackgroundColorIndex { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples

    The following code illustrates how to set a color from ExcelKnownColors enumeration to marker applied.

    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.Circle;
    
        //Set color
        format.MarkerBackgroundColorIndex = ExcelKnownColors.Red;
        format.MarkerForegroundColorIndex = ExcelKnownColors.Black;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    MarkerForegroundColor

    Gets or sets the marker fill color.

    Declaration
    Color MarkerForegroundColor { get; set; }
    Property Value
    Type
    Color
    Examples

    The following code illustrates how to set color for markers 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.ChartType = ExcelChartType.Line;
    
        //Set serie format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set marker style
        format.MarkerStyle = ExcelChartMarkerType.Circle;
    
        //Set color
        format.MarkerBackgroundColor = System.Drawing.Color.Red;
        format.MarkerForegroundColor = System.Drawing.Color.Black;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    MarkerForegroundColorIndex

    Gets or sets the index of marker fill color from predefined colors (ExcelKnownColors).

    Declaration
    ExcelKnownColors MarkerForegroundColorIndex { get; set; }
    Property Value
    Type
    ExcelKnownColors
    Examples

    The following code illustrates how to set a color from ExcelKnownColors enumeration to marker applied.

    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.Circle;
    
        //Set color
        format.MarkerBackgroundColorIndex = ExcelKnownColors.Red;
        format.MarkerForegroundColorIndex = ExcelKnownColors.Black;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    MarkerSize

    Gets or sets the size of markers.

    Declaration
    int MarkerSize { get; set; }
    Property Value
    Type
    int
    Examples

    The following code illustrates how to set MarkerSize for applied markers 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.ChartType = ExcelChartType.Line;
    
        //Set serie format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set marker style
        format.MarkerStyle = ExcelChartMarkerType.Circle;
    
        //Set marker size
        format.MarkerSize = 10;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    MarkerStyle

    Gets or sets the marker style for a point or series in a line chart, scatter chart, or radar chart.

    Declaration
    ExcelChartMarkerType MarkerStyle { get; set; }
    Property Value
    Type
    ExcelChartMarkerType
    Examples

    The following code illustrates how marker style can be applied to 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.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();
    }

    Percent

    Gets or sets the distance of pie slice from center of pie.

    Declaration
    int Percent { get; set; }
    Property Value
    Type
    int
    Examples

    The following code illustrates how to set Percent 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"].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.Pie;
    
        //Set percent
        chart.Series[0].SerieFormat.Percent = 30;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    QuartileCalculationType

    Gets / Sets whether the Quartile calculation is InclusiveMedian or ExclusiveMedian.

    Declaration
    ExcelQuartileCalculation QuartileCalculationType { get; set; }
    Property Value
    Type
    ExcelQuartileCalculation
    Remarks

    Applies only to BoxAndWhisker Charts

    Examples

    By default QuartileCalculationType for BoxAndWhisker is set to ExclusiveMedian. Here for example, we set InclusiveMedian to QuartileCalculationType 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.ImportDataTable(GetData(), true, 1, 1);
    
            //Create chart
            IChart chart = sheet.Charts.Add();
    
            //Set chart type
            chart.ChartType = ExcelChartType.BoxAndWhisker;
    
            //Set range
            chart.DataRange = sheet.Range["B1:C17"];
    
            //Set serie data format
            IChartSerieDataFormat format = chart.Series[0].DataPoints.DefaultDataPoint.DataFormat;
    
            //Set quartile calculation type
            format.QuartileCalculationType = ExcelQuartileCalculation.InclusiveMedian;
    
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    System.Data.DataTable GetData()
    {
        System.Data.DataTable dt = new System.Data.DataTable();
        dt.Columns.Add("Book ID");
        dt.Columns.Add("Category");
        dt.Columns.Add("Price");
        dt.Rows.Add("SBA2465", "Children's", 26);
        dt.Rows.Add("SBA3222", "Children's", 8);
        dt.Rows.Add("SBA2391", "Children's", 9);
        dt.Rows.Add("SBA3823", "Children's", 17);
        dt.Rows.Add("SBA3197", "Children's", 32);
        dt.Rows.Add("SBA1160", "Romance", 34);
        dt.Rows.Add("SBA3092", "Romance", 20);
        dt.Rows.Add("SBA1016", "Romance", 5);
        dt.Rows.Add("SBA3266", "Romance", 12);
        dt.Rows.Add("SBA3381", "Romance", 13);
        dt.Rows.Add("SBA1870", "Romance", 4);
        dt.Rows.Add("SBA2072", "Mystery", 61);
        dt.Rows.Add("SBA3969", "Mystery", 15);
        dt.Rows.Add("SBA3124", "Mystery", 40);
        dt.Rows.Add("SBA3693", "Mystery", 19);
        dt.Rows.Add("SBA2543", "Mystery", 72);
        return dt;
    }

    ShowConnectorLines

    Gets / Sets a boolean value indicating whether to display Connector Lines between data points

    Declaration
    bool ShowConnectorLines { get; set; }
    Property Value
    Type
    bool
    Remarks

    Applies only to Waterfall Charts

    Examples

    The following code illustrates how to set connector line visibility for WaterFall 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 range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set chart type
        chart.ChartType = ExcelChartType.WaterFall;
    
        //Set serie format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set visibility
        format.ShowConnectorLines = false;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ShowInnerPoints

    Gets / Sets a boolean value indicating whether to display Inner Points in BoxAndWhisker chart.

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

    The following code illustrates how to set the visibility of inner points in BoxAndWhisker 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.ImportDataTable(GetData(), true, 1, 1);
    
            //Create chart
            IChart chart = sheet.Charts.Add();
    
            //Set chart type
            chart.ChartType = ExcelChartType.BoxAndWhisker;
    
            //Set range
            chart.DataRange = sheet.Range["B1:C17"];
    
            //Set serie data format
            IChartSerieDataFormat format = chart.Series[0].DataPoints.DefaultDataPoint.DataFormat;
    
            //Set ShowInnerPoints
            format.ShowInnerPoints = true;
    
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    System.Data.DataTable GetData()
    {
        System.Data.DataTable dt = new System.Data.DataTable();
        dt.Columns.Add("Book ID");
        dt.Columns.Add("Category");
        dt.Columns.Add("Price");
        dt.Rows.Add("SBA2465", "Children's", 26);
        dt.Rows.Add("SBA3222", "Children's", 8);
        dt.Rows.Add("SBA2391", "Children's", 9);
        dt.Rows.Add("SBA3823", "Children's", 17);
        dt.Rows.Add("SBA3197", "Children's", 32);
        dt.Rows.Add("SBA1160", "Romance", 34);
        dt.Rows.Add("SBA3092", "Romance", 20);
        dt.Rows.Add("SBA1016", "Romance", 5);
        dt.Rows.Add("SBA3266", "Romance", 12);
        dt.Rows.Add("SBA3381", "Romance", 13);
        dt.Rows.Add("SBA1870", "Romance", 4);
        dt.Rows.Add("SBA2072", "Mystery", 61);
        dt.Rows.Add("SBA3969", "Mystery", 15);
        dt.Rows.Add("SBA3124", "Mystery", 40);
        dt.Rows.Add("SBA3693", "Mystery", 19);
        dt.Rows.Add("SBA2543", "Mystery", 72);
        return dt;
    }

    ShowMeanLine

    Gets / Sets a boolean value indicating whether to display Mean Line in BoxAndWhisker chart

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

    The following code illustrates how to set the visibility of mean lines in BoxAndWhisker 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 range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set chart type
        chart.ChartType = ExcelChartType.BoxAndWhisker;
    
        //Set serie format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set visibility
        format.ShowMeanLine = true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ShowMeanMarkers

    Gets / Sets a boolean value indicating whether to display Mean Marker in BoxAndWhisker chart.

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

    The following code illustrates how to set the visibility of mean markers in BoxAndWhisker 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 range
        chart.DataRange = sheet.Range["A1:C2"];
    
        //Set chart type
        chart.ChartType = ExcelChartType.BoxAndWhisker;
    
        //Set serie format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set visibility
        format.ShowMeanMarkers = true;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    ShowOutlierPoints

    Gets / Sets a boolean value indicating whether to display Outlier Points in BoxAndWhisker chart.

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

    The following code illustrates how to set the visibility of outlier points in BoxAndWhisker 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.ImportDataTable(GetData(), true, 1, 1);
    
            //Create chart
            IChart chart = sheet.Charts.Add();
    
            //Set chart type
            chart.ChartType = ExcelChartType.BoxAndWhisker;
    
            //Set range
            chart.DataRange = sheet.Range["B1:C17"];
    
            //Set serie data format
            IChartSerieDataFormat format = chart.Series[0].DataPoints.DefaultDataPoint.DataFormat;
    
            //Set ShowOutlierPoints
            format.ShowOutlierPoints = true;
    
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    System.Data.DataTable GetData()
    {
        System.Data.DataTable dt = new System.Data.DataTable();
        dt.Columns.Add("Book ID");
        dt.Columns.Add("Category");
        dt.Columns.Add("Price");
        dt.Rows.Add("SBA2465", "Children's", 26);
        dt.Rows.Add("SBA3222", "Children's", 8);
        dt.Rows.Add("SBA2391", "Children's", 9);
        dt.Rows.Add("SBA3823", "Children's", 17);
        dt.Rows.Add("SBA3197", "Children's", 32);
        dt.Rows.Add("SBA1160", "Romance", 34);
        dt.Rows.Add("SBA3092", "Romance", 20);
        dt.Rows.Add("SBA1016", "Romance", 5);
        dt.Rows.Add("SBA3266", "Romance", 12);
        dt.Rows.Add("SBA3381", "Romance", 13);
        dt.Rows.Add("SBA1870", "Romance", 4);
        dt.Rows.Add("SBA2072", "Mystery", 61);
        dt.Rows.Add("SBA3969", "Mystery", 15);
        dt.Rows.Add("SBA3124", "Mystery", 40);
        dt.Rows.Add("SBA3693", "Mystery", 19);
        dt.Rows.Add("SBA2543", "Mystery", 72);
        return dt;
    }

    TreeMapLabelOption

    Gets / Sets the Display label position in Tree map chart

    Declaration
    ExcelTreeMapLabelOption TreeMapLabelOption { get; set; }
    Property Value
    Type
    ExcelTreeMapLabelOption
    Examples

    For TreeMap chart by default TreeMapLabelOption is set to Overlapping. Here for example, we set Banner to TreeMapLabelOption.

    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 = "Fall";
        sheet.Range["B1"].Text = "Month";
        sheet.Range["C1"].Text = "Total";
        sheet.Range["A2:A4"].Text = "Quarter1";
        sheet.Range["A5:A7"].Text = "Quarter2";
        sheet.Range["B2"].Text = "Jan";
        sheet.Range["B3"].Text = "Feb";
        sheet.Range["B4"].Text = "Mar";
        sheet.Range["B5"].Text = "Apr";
        sheet.Range["B6"].Text = "May";
        sheet.Range["B7"].Text = "Jun";
        sheet.Range["C2"].Value = "10";
        sheet.Range["C3"].Value = "20";
        sheet.Range["C4"].Value = "30";
        sheet.Range["C5"].Value = "35";
        sheet.Range["C6"].Value = "25";
        sheet.Range["C7"].Value = "15";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set chart type
        chart.ChartType = ExcelChartType.TreeMap;
    
        //Set range
        chart.DataRange = sheet.Range["A1:C7"];
    
        //Set chart format
        IChartSerieDataFormat format = chart.Series[0].SerieFormat;
    
        //Set label option
        format.TreeMapLabelOption = ExcelTreeMapLabelOption.Banner;
    
        //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