I am using Spire.XLS Chart in Excel in C #
I need to create a chart like the one attached, someone who can help me know how I can generate it, I think it would be the LineMarkers
I am trying to generate the graphic with a one line using this code but it does not work :cry:
workbook.CreateEmptySheets(1);
Worksheet sheet = workbook.Worksheets[0];
Chart chart = null;
chart = sheet.Charts.Add(ExcelChartType.LineMarkers);
sheet.Name = "Chart data";
sheet.GridLinesVisible = false;
chart.DataRange = sheet.Range["B1:B4"];
chart.SeriesDataFromRange = false;
chart.TopRow = 6;
chart.BottomRow = 25;
chart.LeftColumn = 2;
chart.RightColumn = 9;
chart.ChartTitle = "Tiempo de atención";
chart.ChartTitleArea.IsBold = true;
chart.ChartTitleArea.Size = 12;
sheet.Range["A1"].Value = "Mes";
sheet.Range["A2"].Value = "mayo, 2020";
sheet.Range["A3"].Value = "junio, 2020";
sheet.Range["A4"].Value = "Julio, 2020";
sheet.Range["B1"].Value = "Tiempo de atención";
sheet.Range["B2"].Value = "00:01:02";
sheet.Range["B3"].Value = "00:00:00";
sheet.Range["B4"].Value = "00:01:38";
Spire.Xls.Charts.ChartSerie cs1 = chart.Series[0];
cs1.CategoryLabels = sheet.Range["A2:A4"];
cs1.ErrorBar(true, ErrorBarIncludeType.Plus, ErrorBarType.Percentage, 10);
stream = new MemoryStream();
workbook.SaveToStream(stream, Spire.Xls.FileFormat.Version2010);
workbook.SaveToFile(Documento.TemplatesEventReport + "S3.xlsx", ExcelVersion.Version2010);
Image image = workbook.SaveChartAsImage(sheet, 0);