weired plotting

[Mike]

When cells with formula like ="", cells return empty value
(blank cells). However, if trying to plot these cells,
the plot will show zeros versus row numbers. Anyone knows
how to fix the problem?
Thx in advance.

 

[Jon Peltier]

Mike -

Those aren't empty cells, nor are they blanks. They are text strings,
and Excel treats them like zeros, same as any text strings. Change the
"" in your formula to NA(), which puts the #N/A error into the cells.
They look ugly in the worksheet, but the chart ignores them. You can
use conditional formatting to hide the errors in the sheet.

- Jon