com.aspose.cells.ChartPointCollection.html Maven / Gradle / Ivy

Example:

//Instantiating a Workbook object
 Workbook workbook = new Workbook();
 
 //Obtaining the reference of the first worksheet
 Worksheet worksheet = workbook.getWorksheets().get(0);
 
 //Adding a sample value to "A1" cell
 worksheet.getCells().get("A1").putValue(50);
 
 //Adding a sample value to "A2" cell
 worksheet.getCells().get("A2").putValue(100);
 
 //Adding a sample value to "A3" cell
 worksheet.getCells().get("A3").putValue(150);
 
 //Adding a sample value to "B1" cell
 worksheet.getCells().get("B1").putValue(60);
 
 //Adding a sample value to "B2" cell
 worksheet.getCells().get("B2").putValue(32);
 
 //Adding a sample value to "B3" cell
 worksheet.getCells().get("B3").putValue(50);
 
 //Adding a chart to the worksheet
 int chartIndex = worksheet.getCharts().add(ChartType.PIE_EXPLODED, 5, 0, 25, 10);
 
 //Accessing the instance of the newly added chart
 Chart chart = worksheet.getCharts().get(chartIndex);
 
 //Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
 chart.getNSeries().add("A1:B3", true);
 
 //Show Data Labels 
 chart.getNSeries().get(0).getDataLabels().setShowValue(true);
 
 ChartPointCollection points = chart.getNSeries().get(0).getPoints();
 
 for (int i = 0; i < points.getCount(); i++)
 {
     //Get Data Point
     ChartPoint point = points.get(i);
     //Set Pir Explosion
     point.setExplosion(15);
     //Set Border Color
     point.getBorder().setColor(com.aspose.cells.Color.getRed());
 }
 
 //Saving the Excel file
 workbook.save("D:\\book1.xls");