Hello all,

I'm trying to plot a graph where some of the valeus in the data range are "", as a result of a formula. This drives excel crazy. Have a look:
excel-question.PNG

as suggested in other threads (like http://www.excelforum.com/excel-gene...hart-data.html )
using NA() instead of "" solves the problem, but then the problem is the table which holds the data is itself horrendous.

I tried playing around with the Select Data >> Hidden and Empty Cells feature, but got nothing.

Is there a way to get a nice looking graph and a table with empty cells (without manually deleting the "" values in the data table) ?
The empty cells should not be regarded as 0s.. I want to see gaps.

Here is the desired outcome:

excel-desired.PNG

Thanks in advance

ANS