Create Charts in xlsx4j

Aspose.Cells - Create Charts

It is possible to add a variety of charts to spreadsheets with Aspose.Cells. Aspose.Cells provides many flexible charting objects.

Java

  

// Instantiating a Workbook object  
Workbook workbook = new Workbook();  

// Obtaining the reference of the first worksheet  
WorksheetCollection worksheets = workbook.getWorksheets();  
Worksheet sheet = worksheets.get(0);  

// Adding some sample values to cells  
Cells cells = sheet.getCells();  

Cell cell = cells.get("A1");  
cell.setValue(50);  

cell = cells.get("A2");  
cell.setValue(100);  

cell = cells.get("A3");  
cell.setValue(150);  

cell = cells.get("B1");  
cell.setValue(4);  

cell = cells.get("B2");  
cell.setValue(20);  

cell = cells.get("B3");  
cell.setValue(50);  

ChartCollection charts = sheet.getCharts();  

// Adding a chart to the worksheet  
int chartIndex = charts.add(ChartType.PYRAMID, 5, 0, 15, 5);  
Chart chart = charts.get(chartIndex);  

// Adding NSeries (chart data source) to the chart ranging from "A1" cells to "B3"  
SeriesCollection serieses = chart.getNSeries();  
serieses.add("A1:B3", true);  

// Saving the Excel file  
workbook.save(dataDir + "Chart_Aspose.xls");  

Download Running Code

• GitHub

Download Sample Code

• GitHub