Excel API Library for Java - Sample Browser | Document Solutions | Scatter chart
[
フレーム]
src="bundle.js">
Refer to the following example code to see how to add a scatter chart in Document Solutions for Excel.
// Create a new workbook
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);
IShape shape = worksheet.getShapes().addChart(ChartType.XYScatter, 350, 20, 360, 230);
worksheet.getRange("A1:D7").setValue(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.getChart().getSeriesCollection().add(worksheet.getRange("A1:B7"), RowCol.Columns);
shape.getChart().getSeriesCollection().add(worksheet.getRange("C1:D7"), RowCol.Columns);
shape.getChart().getChartTitle().setText("Scatter Chart");
//config markers style
ISeries series1 = shape.getChart().getSeriesCollection().get(0);
ISeries series2 = shape.getChart().getSeriesCollection().get(1);
series1.setMarkerStyle(MarkerStyle.Square);
series1.setMarkerSize(10);
series2.setMarkerSize(10);
// Save to an excel file
workbook.save("XYScatterChart.xlsx");
// Create a new workbook
var workbook = Workbook()
val worksheet = workbook.worksheets.get(0)
val shape = worksheet.shapes.addChart(ChartType.XYScatter, 350.0, 20.0, 360.0, 230.0)
worksheet.getRange("A1:D7").value = arrayOf(arrayOf
("Blue", null, "Red", null), arrayOf(55, 964, 67, 475), arrayOf(20, 825, 10, 163), arrayOf(77, 840, 87, 224), arrayOf(182, 596, 46, 196), arrayOf(190, 384, 100, 377), arrayOf(140, 503, 92, 47))
shape.chart.seriesCollection.add(worksheet.getRange("A1:B7"), RowCol.Columns)
shape.chart.seriesCollection.add(worksheet.getRange("C1:D7"), RowCol.Columns)
shape.chart.chartTitle.text = "Scatter Chart"
//config markers style
val series1 = shape.chart.seriesCollection.get(0)
val series2 = shape.chart.seriesCollection.get(1)
series1.markerStyle = MarkerStyle.Square
series1.markerSize = 10
series2.markerSize = 10
// Save to an excel file
workbook.save("XYScatterChart.xlsx")