Syncfusion.XlsIO.Base
Example 


MajorUnitScale Property (IChartCategoryAxis)

Gets or sets the major unit scale value for the IChartCategoryAxis when the CategoryType of the axis is set to ExcelCategoryType.Time.
Syntax
'Declaration
 
Property MajorUnitScale As ExcelChartBaseUnit
'Usage
 
Dim instance As IChartCategoryAxis
Dim value As ExcelChartBaseUnit
 
instance.MajorUnitScale = value
 
value = instance.MajorUnitScale
ExcelChartBaseUnit MajorUnitScale {get; set;}
Example
The following code illustrates how to set major unit scale value for IChartCategoryAxis.
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"].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(2015, 5, 7);
            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 major and minor units
            categoryAxis.MajorUnitScale = ExcelChartBaseUnit.Year;
            categoryAxis.MinorUnitScale = ExcelChartBaseUnit.Month;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also