How to create Excel scatter with straight lines and markers chart in C#, VB.NET?

            // Create the chart
            IChartShape chart = worksheet.Charts.Add();
 
            // Set chart type to Scatter_Line_Markers
            chart.ChartType = ExcelChartType.Scatter_Line_Markers;

            // Set region of Chart data
            chart.DataRange = worksheet["A3:B7"];
 
            // Set chart series in column for assigned data region
            chart.IsSeriesInRows = false;

              // Apply chart elements
              // Set Chart Title
              chart.ChartTitle = "Scatter With Straight Line And Markers Chart";
 
              // Set Legend
              chart.HasLegend = false;
              
              // Set DataLabels
              IChartSerie serie = chart.Series[0];
              serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = true;
              serie.DataPoints.DefaultDataPoint.DataLabels.IsCategoryName = true;
 

using Syncfusion.XlsIO;
using System.Reflection;
using System.IO;
 
namespace ChartSample
{
    class Program
    {
        static void Main(string[] args)
        {
            using (ExcelEngine excelEngine = new ExcelEngine())
            {
                IApplication application = excelEngine.Excel;
                application.DefaultVersion = ExcelVersion.Excel2016;
 
                // Open existing workbook with data entered
                Assembly assembly = typeof(Program).GetTypeInfo().Assembly;
                Stream fileStream = assembly.GetManifestResourceStream("ChartSample.InputTemplate.xlsx");
                IWorkbook workbook = application.Workbooks.Open(fileStream);
                IWorksheet worksheet = workbook.Worksheets[0];
 
                // Initialize chart
                IChartShape chart = worksheet.Charts.Add();
                chart.ChartType = ExcelChartType.Scatter_Line_Markers;
 
                // Assign data
                chart.DataRange = worksheet["A3:B7"];
                chart.IsSeriesInRows = false;
 
                // Apply chart elements
                //Set Chart Title
                chart.ChartTitle = "Scatter With Straight Line And Markers Chart";
 
                // Set Legend
                chart.HasLegend = false;
 
                // Set DataLabels
                IChartSerie serie = chart.Series[0];
                serie1.DataPoints.DefaultDataPoint.DataLabels.IsValue = true; 
                serie1.DataPoints.DefaultDataPoint.DataLabels.IsCategoryName = true;
 
                // Positioning the chart in the worksheet
                chart.TopRow = 8;
                chart.LeftColumn = 1;
                chart.BottomRow = 23;
                chart.RightColumn = 8;
 
                // Saving and closing the workbook
                Stream stream = File.Create("Output.xlsx");
                workbook.SaveAs(stream);
            }
        }
    }
}

Imports Syncfusion.XlsIO
Imports System.Reflection
Imports System.IO
 
Namespace ChartSample
 
    Class Program
 
        Public Shared Sub Main(ByVal args As String())
            Using excelEngine As ExcelEngine = New ExcelEngine()
                Dim application As IApplication = excelEngine.Excel
                application.DefaultVersion = ExcelVersion.Excel2016
 
 
                'Open existing workbook with data entered
                Dim assembly As Assembly = GetType(Program).GetTypeInfo().Assembly
                Dim fileStream As Stream = assembly.GetManifestResourceStream("ChartSample.InputTemplate.xlsx")
                Dim workbook As IWorkbook = application.Workbooks.Open(fileStream)
                Dim worksheet As IWorksheet = workbook.Worksheets(0)
 
                'Initialize chart
                Dim chart As IChartShape = worksheet.Charts.Add()
                chart.ChartType = ExcelChartType.Scatter_Line_Markers
 
                'Assign data
                chart.DataRange = worksheet("A3:B7")
                chart.IsSeriesInRows = False
 
                'Apply chart elements
                'Set Chart Title
                chart.ChartTitle = "Scatter With Straight Line And Markers Chart"
 
                'Set Legend
                chart.HasLegend = False
 
                'Set Datalabels
                IChartSerie serie = chart.Series[0]
                serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = True
                serie.DataPoints.DefaultDataPoint.DataLabels.IsCategoryName = True
 
                'Positioning chart in the worksheet
                chart.TopRow = 8
                chart.LeftColumn = 1
                chart.BottomRow = 23
                chart.RightColumn = 8
 
                'Saving and closing the workbook
                Dim stream As Stream = File.Create("Output.xlsx")
                workbook.SaveAs(stream)
            End Using
        End Sub
    End Class
End Namespace