Hi,

Instead of "" use NA()

Cheers
Andy

TBB wrote:
I have a chart that referrences cells that contain an IF statement that
returns "". Although the chart option 'do not plot blank cells' is marked,
Excel graphs these cells as being 0.

--

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