Hi,
thnaks for the good work and the big help that u provide us.
i created a 3D area chart and i want to show the labels in the secondCategoryAxis.
automatically thy are shown in xls format but not in the xlsx.
i set the function SeconedcategoryAxis.setVisible to true but i keep having no labels in the xlsx format.
here is the code that i use :
Workbook workbook = new Workbook();
WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet sheet = worksheets.get(0);
Cells cells = sheet.getCells();
Cell cell = cells.get(“B4”);
cell.setValue(“January”);
cell = cells.get(“C4”);
cell.setValue(“February”);
//soure data
cell = cells.get(“B5”);
cell.setValue(9300);
cell = cells.get(“C5”);
cell.setValue(1280);
cell = cells.get(“B6”);
cell.setValue(11300);
cell = cells.get(“C6”);
cell.setValue(21000);
cell = cells.get(“B7”);
cell.setValue(13200);
cell = cells.get(“C7”);
cell.setValue(11000);
Style style = workbook.createStyle();
style.setNumber(5);
// cells.setRangeStyle(4, 6, 1, 2, style);
//catergory
cell = cells.get(“A5”);
cell.setValue(“Chicago”);
cell = cells.get(“A6”);
cell.setValue(“Dallas”);
cell = cells.get(“A7”);
cell.setValue(“Boston”);
//
//sheet = worksheets.addSheet(SheetType.CHART,“chartsheet”)
ChartCollection charts = sheet.getCharts();
//Adding a chart to the worksheet
int chartIndex = charts.add(ChartType.AREA_3_D, 10, 5, 22, 12);
Chart chart = charts.get(chartIndex);
//Adding NSeries (chart data source) to the chart ranging from “B5” cell to “C7”
SeriesCollection nSeries = chart.getNSeries();
nSeries.add(“B5:C7”, true);
chart.getSecondCategoryAxis().setVisible(true);
//Setting the data source for the category data of NSeries
nSeries.setCategoryData(“A5:A7”);
//setting sereis name
Series aSeries = nSeries.get(0);
aSeries.setName("=B4");
aSeries = nSeries.get(1);
aSeries.setName("=C4");
workbook.save(“C:\Users\ark\Desktop\ASPOSE CELL\tests_examples\” + “area.xls”);
workbook.save(“C:\Users\ark\Desktop\ASPOSE CELL\tests_examples\” + “area.xlsx”);
