Syncfusion.XlsIO.Base
Example 


IsBinningByCategory Property (IChartCategoryAxis)

True if bins generated by category values. otherwise False
Syntax
'Declaration
 
Property IsBinningByCategory As Boolean
'Usage
 
Dim instance As IChartCategoryAxis
Dim value As Boolean
 
instance.IsBinningByCategory = value
 
value = instance.IsBinningByCategory
bool IsBinningByCategory {get; set;}
Remarks
Example
By default IsBinningByCategory is set to "true" so chart serie are grouped based on category labels. Here for example, we set "false" to IsBinningByCategory 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.IsBinningByCategory = false;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also