Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChart Interface : PrimaryCategoryAxis Property

PrimaryCategoryAxis Property (IChart)

Gets the primary category axis of the chart. Read-only.
Syntax
'Declaration
 
ReadOnly Property PrimaryCategoryAxis As IChartCategoryAxis
'Usage
 
Dim instance As IChart
Dim value As IChartCategoryAxis
 
value = instance.PrimaryCategoryAxis
IChartCategoryAxis PrimaryCategoryAxis {get;}
Remarks
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.
Example
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
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also