Can you not create a separate set of cells, which can be 'tampered'
with, and use these for the charting data. This cells could be in cells
away from the main report or even on another sheet.

Cheers
Andy

Hari wrote:
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info