Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartCategoryAxis Interface : EnteredDirectlyCategoryLabels Property

EnteredDirectlyCategoryLabels Property (IChartCategoryAxis)

Gets or sets the directly entered category labels for the chart.
Syntax
'Declaration
 
Property EnteredDirectlyCategoryLabels As Object()
'Usage
 
Dim instance As IChartCategoryAxis
Dim value() As Object
 
instance.EnteredDirectlyCategoryLabels = value
 
value = instance.EnteredDirectlyCategoryLabels
object[] EnteredDirectlyCategoryLabels {get; set;}
Example
The following code illustrates how to set category labels directly for charts.
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"];
            
            //Set chart category axis
            IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;
            
            //Set category labels directly
            categoryAxis.EnteredDirectlyCategoryLabels = new object[] { "Oct", "Nov", "Dec" };
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also