//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; GrapeCity.Documents.Excel.Drawing.IShape shape = worksheet.Shapes.AddChart(GrapeCity.Documents.Excel.Drawing.ChartType.XYScatter, 250, 20, 360, 230); worksheet.Range["A1:D7"].Value = new object[,] { { "Blue", null, "Red", null }, { 55, 964, 67, 475 }, { 20, 825, 10, 163 }, { 77, 840, 87, 224 }, { 182, 596, 46, 196 }, { 190, 384, 100, 377 }, { 140, 503, 92, 47 }, }; shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B7"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns); shape.Chart.SeriesCollection.Add(worksheet.Range["C1:D7"], GrapeCity.Documents.Excel.Drawing.RowCol.Columns); shape.Chart.ChartTitle.Text = "Scatter Chart"; //config markers style GrapeCity.Documents.Excel.Drawing.ISeries series1 = shape.Chart.SeriesCollection[0]; GrapeCity.Documents.Excel.Drawing.ISeries series2 = shape.Chart.SeriesCollection[1]; series1.MarkerStyle = Drawing.MarkerStyle.Square; series1.MarkerSize = 10; series2.MarkerSize = 10; // Save to an excel file workbook.Save("XYScatterChart.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim shape As IShape = worksheet.Shapes.AddChart(ChartType.XYScatter, 250, 20, 360, 230) worksheet.Range("A1:D7").Value = New Object(,) { {"Blue", Nothing, "Red", Nothing}, {55, 964, 67, 475}, {20, 825, 10, 163}, {77, 840, 87, 224}, {182, 596, 46, 196}, {190, 384, 100, 377}, {140, 503, 92, 47} } shape.Chart.SeriesCollection.Add(worksheet.Range("A1:B7"), RowCol.Columns) shape.Chart.SeriesCollection.Add(worksheet.Range("C1:D7"), RowCol.Columns) shape.Chart.ChartTitle.Text = "Scatter Chart" 'config markers style Dim series1 As ISeries = shape.Chart.SeriesCollection(0) Dim series2 As ISeries = shape.Chart.SeriesCollection(1) series1.MarkerStyle = MarkerStyle.Square series1.MarkerSize = 10 series2.MarkerSize = 10 ' save to an excel file workbook.Save("XYScatterChart.xlsx")