Syncfusion.XlsIO Namespace > IChart Interface : PrimaryCategoryAxis Property

PrimaryCategoryAxis Property (IChart)

Gets the primary category axis of the chart. Read-only.
ReadOnly Property PrimaryCategoryAxis As IChartCategoryAxis
Dim instance As IChart
Dim value As IChartCategoryAxis
value = instance.PrimaryCategoryAxis
IChartCategoryAxis PrimaryCategoryAxis {get;}
Charts are plotted using X and Y axes. The Y axes typically have numerical scales, whereas the X axes typically have categorical scales. Some charts, for example, have axes, and others, like PieChart don't. Most charts have horizontal axis of type PrimaryCategoryAxis and vertical axis of type PrimaryValueAxis but some, like BarChart, have the opposite. PrimaryCategoryAxis represents an axis used for categories. Categories can include string, numeric, and date values.
The following code illustrates how to set the visibility of PrimaryCategoryAxis.
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 range
            chart.DataRange = sheet.Range["A1:C2"];
            //Chart category axis
            IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;
            //Set visibility
            categoryAxis.Visible = false;
            //Save and Dispose

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also