Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartSerie Interface : EnteredDirectlyBubbles Property

EnteredDirectlyBubbles Property

Gets or sets the directly entered series values for ExcelChartType.Bubble chart.
Syntax
'Declaration
 
Property EnteredDirectlyBubbles As Object()
'Usage
 
Dim instance As IChartSerie
Dim value() As Object
 
instance.EnteredDirectlyBubbles = value
 
value = instance.EnteredDirectlyBubbles
object[] EnteredDirectlyBubbles {get; set;}
Example
The following code illustrates how series data for second value axis of ExcelChartType.Bubble charts can be directly given 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];
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set serie
            IChartSerie serie = chart.Series.Add(ExcelChartType.Bubble);
            
            //Set direct values
            serie.EnteredDirectlyValues = new object[] { 10, 20, 30 };
            
            //Set bubble chart direct values
            serie.EnteredDirectlyBubbles = new object[] { 1, 4, 2 };
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also