How do i keep cells with a formula returning "" from being plotted

[TBB]

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]

Hi,

Instead of "" use NA()

Cheers
Andy

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.

 

[bj]

unfortunately "" will plot as a zero
#NA will plot as interpolated with no symbol
if you do not want to be able to use the Do not plot at all aspect, what I
have done is make the cells I dont' want to plot be a uniques character,
copy the data select all paste special values somewhere else. use find
replace and relaplace the unique characer with nothing. Then plot this data.