Hey,
exists out there a way to generate a chart with null values.
an example what i m searching for is in the attachments.
thx
Thomas
......
serie.EnteredDirectlyValues = new object[] { 10, "", 30 };
serie.EnteredDirectlyCategoryLabels = new object[] { "Label1", "Label2", "Label3" };
......
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
Chart chart = sheet.Charts.Add(ExcelChartType.LineMarkersStacked);
var serie = chart.Series.Add();
serie.EnteredDirectlyValues = new object[] { "", 20, 30 };
serie.EnteredDirectlyCategoryLabels = new object[] { "Label1", "Label2", "Label3" };
workbook.SaveToFile("result.xlsx", ExcelVersion.Version2013);