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.

"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.