I have set my cell values to Blank by using "". Unfortunately, these cell values show up as zeros when charting. Is there any way to avoid this?
I realize that I can instead use #N/A for my blank cells, and then the chart works fine. However, I prefer that the cells look empty (as with "").