Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChart Interface : PrimaryValueAxis Property

PrimaryValueAxis Property (IChart)

Gets the primary value axis. Read-only.
Syntax
'Declaration
 
ReadOnly Property PrimaryValueAxis As IChartValueAxis
'Usage
 
Dim instance As IChart
Dim value As IChartValueAxis
 
value = instance.PrimaryValueAxis
IChartValueAxis PrimaryValueAxis {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. PrimaryValueAxis represents an axis used for series values.
Example
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
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also