Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartCategoryAxis Interface : AutoTickLabelSpacing Property

AutoTickLabelSpacing Property (IChartCategoryAxis)

Gets or sets whether or not the tick label spacing is automatic.
Syntax
'Declaration
 
Property AutoTickLabelSpacing As Boolean
'Usage
 
Dim instance As IChartCategoryAxis
Dim value As Boolean
 
instance.AutoTickLabelSpacing = value
 
value = instance.AutoTickLabelSpacing
bool AutoTickLabelSpacing {get; set;}
Example
The following code illustrates how to access AutoTickLabelSpacing 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"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["D1"].Text = "Apr";
            sheet.Range["E1"].Text = "May";
            sheet.Range["F1"].Text = "Jun";
            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 tick label spacing
            categoryAxis.TickLabelSpacing = 2;
            
            //Check auto spacing
            Console.Write(categoryAxis.AutoTickLabelSpacing);
            
            //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