import com.spire.xls.*;
import com.spire.xls.charts.ChartSerie;
import com.spire.xls.charts.ChartSeries;
import java.awt.*;
public class LineChart {
public static void main(String[] args) {
//创建Workbook对象
Workbook workbook = new Workbook();
//获取第一个工作表
Worksheet sheet =
workbook.getWorksheets().get(0);
//将图表数据写入工作表
sheet.getCellRange("A1").setValue("月份");
sheet.getCellRange("A2").setValue("一月");
sheet.getCellRange("A3").setValue("二月");
sheet.getCellRange("A4").setValue("三月");
sheet.getCellRange("A5").setValue("四月");
sheet.getCellRange("A6").setValue("五月");
sheet.getCellRange("A7").setValue("六月");
sheet.getCellRange("B1").setValue("台式电脑");
sheet.getCellRange("B2").setNumberValue(80);
sheet.getCellRange("B3").setNumberValue(45);
sheet.getCellRange("B4").setNumberValue(25);
sheet.getCellRange("B5").setNumberValue(20);
sheet.getCellRange("B6").setNumberValue(10);
sheet.getCellRange("B7").setNumberValue(5);
sheet.getCellRange("C1").setValue("手提电脑");
sheet.getCellRange("C2").setNumberValue(30);
sheet.getCellRange("C3").setNumberValue(25);
sheet.getCellRange("C4").setNumberValue(35);
sheet.getCellRange("C5").setNumberValue(50);
sheet.getCellRange("C6").setNumberValue(45);
sheet.getCellRange("C7").setNumberValue(55);
sheet.getCellRange("D1").setValue("平板电脑");
sheet.getCellRange("D2").setNumberValue(10);
sheet.getCellRange("D3").setNumberValue(15);
sheet.getCellRange("D4").setNumberValue(20);
sheet.getCellRange("D5").setNumberValue(35);
sheet.getCellRange("D6").setNumberValue(60);
sheet.getCellRange("D7").setNumberValue(95);
//设置单元格样式
sheet.getCellRange("A1:D1").setRowHeight(15);
sheet.getCellRange("A1:D1").getCellStyle().setColor(Color.darkGray);
sheet.getCellRange("A1:D1").getCellStyle().getExcelFont().setColor(Color.white);
sheet.getCellRange("A1:D1").getCellStyle().setVerticalAlignment(VerticalAlignType.Center);
sheet.getCellRange("A1:D1").getCellStyle().setHorizontalAlignment(HorizontalAlignType.Center);
//添加折线图
Chart chart =
sheet.getCharts().add(ExcelChartType.Line);
//设置图表数据区域
chart.setDataRange(sheet.getCellRange("A1:D7"));
chart.setSeriesDataFromRange(false);
//设置图表位置
chart.setLeftColumn(6);
chart.setTopRow(1);
chart.setRightColumn(15);
chart.setBottomRow(21);
//设置图表标题
chart.setChartTitle("产品销售趋势图");
chart.getChartTitleArea().isBold(true);
chart.getChartTitleArea().setSize(12);
//设置x,y轴的名称
chart.getPrimaryCategoryAxis().setTitle("月份");
chart.getPrimaryCategoryAxis().getFont().isBold(true);
chart.getPrimaryCategoryAxis().getTitleArea().isBold(true);
chart.getPrimaryValueAxis().setTitle("销售量");
chart.getPrimaryValueAxis().hasMajorGridLines(false);
chart.getPrimaryValueAxis().getTitleArea().setTextRotationAngle(90);
chart.getPrimaryValueAxis().getTitleArea().isBold(true);
//设置系列颜色和数字标签
ChartSeries series =
chart.getSeries();
for (int i = 0; i < series.size(); i++) {
ChartSerie cs = series.get(i);
cs.getFormat().getOptions().isVaryColor(true);
cs.getDataPoints().getDefaultDataPoint().getDataLabels().hasValue(true);
cs.getDataFormat().setMarkerStyle(ChartMarkerType.Circle);
}
//设置图例位置
chart.getLegend().setPosition(LegendPositionType.Top);
//保存文档
workbook.saveToFile("LineChart.xlsx", ExcelVersion.Version);
}
}
如果觉得《java图表标题_Java 创建Excel图表》对你有帮助,请点赞、收藏,并留下你的观点哦!