Excel Connect data points with line is DISABLED

Question

In Excel, I have a graph for a prepared table.

The "Connect data points with line" option are disabled, and I'm experiencing the traditional problem of empty numbers being displayed on the graph as zero. I can't verify it.

I googled it but never found the answer. Does anybody know why?

Answer 1

By replicating the data series and substituting zero values with #NA, I was able to get around a similar issue, and my chart then functioned as intended.

Although I have not yet located it, it is someplace on this site:

enter the link description here