Bernard Liengme wrote...
....
For charts: make chart, click on it; use Tools|Options; open Chart tab; set
"Plot empty cells as" to Interpolate
....

I believe you're missing the OP's point. The OP wouldn't have a problem
if the cells in his/her chart range were truly blank, which would be
why the OP is asking how to generate blank cells. If the OP is using ""
as a proxy for blank, then the chart option you mention doesn't help -
Excel *ALWAYS* plots text values as zeros. REALLY STUPID, but this just
wouldn't be Excel if there weren't a few (dozen? hundred?) stupid
design 'features'.