I am using Spire.Xls to create a line chart with error bars in xlsx document. Then I convert chart into image using following code:
- Code: Select all
Worksheet sheet=workbook.Worksheets[0];
var imgs= workbook.SaveChartAsImage(sheet).Select(s => System.Drawing.Image.FromStream(s));
for (int i = 0; i < imgs.Count; i++)
{
var imgPath = "Image_" + i + ".png";
imgs[i].Save(imgPath, ImageFormat.Png);
}
The images are created but the problem is, that error bars in images are displayed before the chart line and it looks different than chart in excel.
Is there any way to keep error bars behind chart line?
Best regards,
Gašper