private void ChartDraw2(string title_name) { chart = ws2.Charts.Add(); chart.ChartType = ExcelChartType.Line; chart.DataRange = ws2.Range["A1:I7"]; chart.LeftColumn = 12; chart.TopRow = 7; chart.RightColumn = 20; chart.BottomRow = 22; //标题名称 chart.ChartTitle = title_name; chart.ChartTitleArea.IsBold = true; chart.ChartTitleArea.Size = 12; //设置横坐标的标题 chart.PrimaryCategoryAxis.Title = "时间"; chart.PrimaryCategoryAxis.Font.IsBold = true; chart.PrimaryCategoryAxis.TitleArea.IsBold = true; //y chart.PrimaryValueAxis.Title = "数值"; chart.PrimaryValueAxis.HasMajorGridLines = false; chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90; chart.PrimaryValueAxis.MinValue = 0; chart.PrimaryValueAxis.TitleArea.IsBold = true; //循环绘制 foreach (Spire.Xls.Charts.ChartSerie cs in chart.Series) { cs.Format.Options.IsVaryColor = true; cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = true; } Image[] image = wb2.SaveChartAsImage(ws2); image[0].Save(pic_fuyun_path, ImageFormat.Png); }