Syncfusion.XlsIO.Base
Example 


BinWidth Property (IChartCategoryAxis)

Get or Set the number of data points in each range.
Syntax
'Declaration
 
Property BinWidth As Double
'Usage
 
Dim instance As IChartCategoryAxis
Dim value As Double
 
instance.BinWidth = value
 
value = instance.BinWidth
double BinWidth {get; set;}
Remarks
Example
The following code illustrates how to set the grouping width for ExcelChartType.Histogram and ExcelChartType.Pareto charts.
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";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set chart type
            chart.ChartType = ExcelChartType.Pareto;
            
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            
            //Set chart category axis
            IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;
            
            //Set category axis bin width
            categoryAxis.BinWidth = 7;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also