Syncfusion.XlsIO Namespace > IChart Interface : PrimaryValueAxis Property

PrimaryValueAxis Property (IChart)

Gets the primary value axis. Read-only.
ReadOnly Property PrimaryValueAxis As IChartValueAxis
Dim instance As IChart
Dim value As IChartValueAxis
value = instance.PrimaryValueAxis
IChartValueAxis PrimaryValueAxis {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. PrimaryValueAxis represents an axis used for series values.
The following code illustrates how to set visibility of PrimaryValueAxis.
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 value axis
            IChartValueAxis valueAxis = chart.PrimaryValueAxis;
            //Set visibility
            valueAxis.Visible = false;
            //Save and Dispose

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also