Bernard,

I tried it right now and it wouldnt work for my case.

Replacing the values by NA would amount to "tampering" with my report.
In the same vein I cannot delete the zeroes in my data as they are
formulas and not punched in values. Do we have a way where we can read
the array of values from worksheet and this is given as an argument to
a formula which could return all the array values back with zero
replaced by missing values. That way one can use this function in the
series formula for chart.

Regards,
HP
India