Thread: Chart "Connect data points with line" for "Hidden and empty cells"

Hi!

With a line chart I'm having the following problem. I have data produced by formulas, which can produce either a value or empty. I want to make a line chart where data points are the non-empty values and the empty cells are connected by a line.

But using the "Hidden and empty cells" option of chart, it considers the empty cells as zeros, not blanks, if the "emptiness" is returned by a formula. Is this a bug in Excel or a problem in my usage?

Attached is a screenshot with comments, which might clarify the issue, and also the sample excel from which the screenshot was taken.

Thanks in advance!
Suni.

Hi!

Yes, thanks, that helped! Now I get the chart neatly connected as I want. Only minor elegance issue anymore is, that I'd prefer not seeing the #N/A in the actual cells, but that's not a big thing, because those cells are anyway only used in calculation, not printed out as such.

Thanks for the help!

Suni

Thanks, I could try that.

Suni.