Syncfusion.XlsIO.Base
Example 


DisplayUnit Property (IChartValueAxis)

Returns or sets the unit label for the specified axis.
Syntax
'Declaration
 
Property DisplayUnit As ExcelChartDisplayUnit
'Usage
 
Dim instance As IChartValueAxis
Dim value As ExcelChartDisplayUnit
 
instance.DisplayUnit = value
 
value = instance.DisplayUnit
ExcelChartDisplayUnit DisplayUnit {get; set;}
Example
By default the value axis displays no unit labels since DisplayUnitLabel is set to ExcelChartDisplayUnit.None by default. Here for example, we set ExcelChartDisplayUnit.Hundreds to DisplayUnitLabel.
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 = "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;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also