Syncfusion.XlsIO.Base
Example 


HasAutomaticBins Property (IChartCategoryAxis)

True if bins generated are automatic. otherwise False
Syntax
'Declaration
 
Property HasAutomaticBins As Boolean
'Usage
 
Dim instance As IChartCategoryAxis
Dim value As Boolean
 
instance.HasAutomaticBins = value
 
value = instance.HasAutomaticBins
bool HasAutomaticBins {get; set;}
Remarks
Example
By default HasAutomaticBins is set to "false" so grouping will be done based on the categories in the IChartCategoryAxis. Here for example, we set HasAutomaticBins to "true" so that chart serie would be grouped automatically.
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 bins to automatic
            categoryAxis.HasAutomaticBins = true;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also