在apache poi中创建图表

Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("图表数据");

Row row1 = sheet.createRow(0);
row1.createCell(0).setCellValue("月份");
row1.createCell(1).setCellValue("销售额");

Row row2 = sheet.createRow(1);
row2.createCell(0).setCellValue("1月");
row2.createCell(1).setCellValue(10000);

Row row3 = sheet.createRow(2);
row3.createCell(0).setCellValue("2月");
row3.createCell(1).setCellValue(15000);

// 添加更多数据...

Drawing drawing = sheet.createDrawingPatriarch();
ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 4, 1, 10, 15);

Chart chart = drawing.createChart(anchor);
chart.setTitleText("销售额统计");
chart.setTitleOverlay(false);

// 设置图表类型为柱状图
ChartLegend legend = chart.getOrCreateLegend();
legend.setPosition(LegendPosition.BOTTOM);

BarChartData data = chart.getChartDataFactory().createBarChartData();

// 设置横轴和纵轴的数据范围
ValueAxis bottomAxis = chart.getChartAxisFactory().createCategoryAxis(AxisPosition.BOTTOM);
ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);
leftAxis.setCrosses(AxisCrosses.AUTO_ZERO);

ChartDataSource<String> categories = DataSources.fromStringCellRange(sheet, new CellRangeAddress(1, 12, 0, 0));
ChartDataSource<Number> values = DataSources.fromNumericCellRange(sheet, new CellRangeAddress(1, 12, 1, 1));

data.addSeries(categories, values);

// 将图表添加到工作表中
chart.plot(data, bottomAxis, leftAxis);

FileOutputStream fileOut = new FileOutputStream("图表.xlsx");
workbook.write(fileOut);
fileOut.close();