Syncfusion.XlsIO.Base
Example 


ShowInnerPoints Property (IChartSerieDataFormat)

Gets / Sets a boolean value indicating whether to display Inner Points in ExcelChartType.BoxAndWhisker chart.
Syntax
'Declaration
 
Property ShowInnerPoints As Boolean
'Usage
 
Dim instance As IChartSerieDataFormat
Dim value As Boolean
 
instance.ShowInnerPoints = value
 
value = instance.ShowInnerPoints
bool ShowInnerPoints {get; set;}
Example
The following code illustrates how to set the visibility of inner points in ExcelChartType.BoxAndWhisker chart.
using Syncfusion.XlsIO;
using System.Data;
            
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.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();
        }
    }
    static DataTable GetData()
    {
        DataTable dt = new 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;
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also