Search code examples
c#epplus

EPPlus set Connect data points with line


I have already draw an excel chart with EPPlus in C# and I need to set Connect data points with line, in order to avoid empty cells affecting my chart.

A correct sample of line chart that ignore Cleared cells and connect data points with line

As you can see in above image, there are two cells with no value (Green ones) and I checked the "Connect data points with line" in excel data options.

But working with EPPlus, I cant find the proper property to set that.


Solution

  • Unfortunately, your reported problem of EPPLus has not been resolved yet! So, as an alternative solution, switch cells whose data is null to #N/A. In this case, Excel will correct the chart automatically.