alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Interface IChartSeriesAxis

    Represents the chart series Axis.

    Inherited Members
    IChartAxis.Alignment
    IChartAxis.AutoTickLabelSpacing
    IChartAxis.AxisType
    IChartAxis.Border
    IChartAxis.Chart3DOptions
    IChartAxis.Font
    IChartAxis.HasMajorGridLines
    IChartAxis.HasMinorGridLines
    IChartAxis.IsReversed
    IChartAxis.MajorGridLines
    IChartAxis.MajorTickMark
    IChartAxis.MinorGridLines
    IChartAxis.MinorTickMark
    IChartAxis.NumberFormat
    IChartAxis.ReversePlotOrder
    IChartAxis.Shadow
    IChartAxis.TextRotationAngle
    IChartAxis.TickLabelPosition
    IChartAxis.Title
    IChartAxis.TitleArea
    IChartAxis.Visible
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public interface IChartSeriesAxis : IChartAxis

    Properties

    LabelFrequency

    Represents the number of categories or series between tick-mark labels.[Deprecated]

    Declaration
    [Obsolete("Please, use TickLabelSpacing instead of it")]
    int LabelFrequency { get; set; }
    Property Value
    Type
    int

    TickLabelSpacing

    Represents the number of categories or series between tick-mark labels.

    Declaration
    int TickLabelSpacing { get; set; }
    Property Value
    Type
    int
    Examples

    The following code illustrates how to set TickLabelSpacing for IChartSeriesAxis.

    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";
        sheet.Range["A3"].Value = "15";
        sheet.Range["B3"].Value = "25";
        sheet.Range["C3"].Value = "35";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C3"];
    
        //Set chart type
        chart.ChartType = ExcelChartType.Column_3D;
    
        //Set tick label spacing 
        chart.PrimarySerieAxis.TickLabelSpacing = 2;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    TickMarkSpacing

    Represents the number of categories or series between tick marks.

    Declaration
    int TickMarkSpacing { get; set; }
    Property Value
    Type
    int
    Examples

    The following code illustrates how to set TickMarkSpacing for IChartSeriesAxis.

    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";
        sheet.Range["A3"].Value = "15";
        sheet.Range["B3"].Value = "25";
        sheet.Range["C3"].Value = "35";
    
        //Create chart
        IChart chart = sheet.Charts.Add();
    
        //Set range
        chart.DataRange = sheet.Range["A1:C3"];
    
        //Set chart type
        chart.ChartType = ExcelChartType.Column_3D;
    
        //Set tick mark spacing 
        chart.PrimarySerieAxis.TickMarkSpacing = 2;
    
        //Save and Dispose
        workbook.SaveAs("Chart.xlsx");
        workbook.Close();
    }

    TickMarksFrequency

    Represents the number of categories or series between tick marks.[Deprecated]

    Declaration
    [Obsolete("Please, use TickMarkSpacing instead of it")]
    int TickMarksFrequency { get; set; }
    Property Value
    Type
    int
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved