Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartValueAxis Interface : HasDisplayUnitLabel Property

HasDisplayUnitLabel Property (IChartValueAxis)

True if the label is displayed on the specified axis.
Syntax
'Declaration
 
Property HasDisplayUnitLabel As Boolean
'Usage
 
Dim instance As IChartValueAxis
Dim value As Boolean
 
instance.HasDisplayUnitLabel = value
 
value = instance.HasDisplayUnitLabel
bool HasDisplayUnitLabel {get; set;}
Example
By default DisplayUnitLabel is set to ExcelChartDisplayUnit.None so display unit label will not be shown. Here for example, we set ExcelChartDisplayUnit.Hundreds to DisplayUnitLabel property so the display unit label will be visible.
using Syncfusion.XlsIO;
using System;
            
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 = "10000";
            sheet.Range["B2"].Value = "20000";
            sheet.Range["C2"].Value = "30000";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            
            //Set chart value axis
            IChartValueAxis valueAxis = chart.PrimaryValueAxis;
            
            //Set display unit
            valueAxis.DisplayUnit = ExcelChartDisplayUnit.Hundreds;
            
            //Check display unit label
            Console.Write(valueAxis.HasDisplayUnitLabel);
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
            Console.ReadKey();
        }
    }
}
//Output will be
//True
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also