I have created an .xlsx file using Aspose cell java APIs having charts.
When I opened it with MS EXCEL the charts are not appearing.
But when I opened the same File Using Google Sheets Charts are appearing properly.
I have also inserted sample code below.
SAMPLE CODE:
ChartCollection charts = sheet.getCharts();
int chartIndex = charts.add(ChartType.BAR_STACKED, 5, 0, 15, 5);
Chart chart = charts.get(chartIndex);
SeriesCollection chartDataSeriesCollection = chart.getNSeries();
String chartInputDataRange = “D5:D10”; //no i18n
chartDataSeriesCollection.add(chartInputDataRange , true);
Series pollVotesSeries = chartDataSeriesCollection.get(0);
pollVotesSeries.setXValues(“C5:C10”); //no i18n
// Saving the Excel file
workbook.save(dataDir + “HToCPyramidChart_out.xls”);
Below is appeared chart screenshot:
Screen Shot 2017-08-30 at 8.58.09 PM.png (7.6 KB)