Syncfusion.XlsIO.Base
Example 


BaseUnitIsAuto Property (IChartCategoryAxis)

True to use automatic base units for the specified category axis. otherwise False.
Syntax
'Declaration
 
Property BaseUnitIsAuto As Boolean
'Usage
 
Dim instance As IChartCategoryAxis
Dim value As Boolean
 
instance.BaseUnitIsAuto = value
 
value = instance.BaseUnitIsAuto
bool BaseUnitIsAuto {get; set;}
Example
The following code illustrates how to access BaseUnitIsAuto property.
using Syncfusion.XlsIO;
using System;
            
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"].DateTime = new System.DateTime(2017, 3, 15);
            sheet.Range["B1"].DateTime = new System.DateTime(2017, 9, 17);
            sheet.Range["C1"].DateTime = new System.DateTime(2017, 5, 2);
            sheet.Range["D1"].DateTime = new System.DateTime(2016, 5, 2);
            sheet.Range["E1"].DateTime = new System.DateTime(2015, 5, 2);
            sheet.Range["F1"].DateTime = new System.DateTime(2011, 5, 2);
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            sheet.Range["D2"].Value = "30";
            sheet.Range["E2"].Value = "20";
            sheet.Range["F2"].Value = "10";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:F2"];
            
            //Set chart category axis
            IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;
            
            //Set category type
            categoryAxis.CategoryType = ExcelCategoryType.Time;
            
            //Set base unit
            categoryAxis.BaseUnit = ExcelChartBaseUnit.Year;
            
            //Check base unit auto or not
            Console.Write(categoryAxis.BaseUnitIsAuto);
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
            Console.ReadKey();
        }
    }
}
//Output will be
//False
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also