Changing value of "" to be blank

[TS]

When you use cells containing formulas that return empty
double quotation marks in the plot range for a chart, the
result for the point values of those cells is zero. For
example, a line chart shows a continuous line going from
the previous point to zero and then to the next point.
Blank cells, however, result in a break in the line rather
than a zero value.

Does anyone know how this can be modified so that""
returns no value?

Thanks

T

 

[Debra Dalgleish]

Instead of an empty string, you can use the NA() function in your formulas:

=IF(B2="",NA(),B2)

 

[Guest]

That does appear to enter a value of "NA" in the cell,
which does not get displayed in any charts referencing
that cell.

Thank you very much.

 

[Guest]

Debra,

Thanks. I thought this worked, however, when I ran a chart
referencing this cell with NA (), the chart has a data
label that now displays #N/A on it rather than the actual
value for that month.

Any other ideas?

 

[Debra Dalgleish]

What type of chart are you creating? In your original post, you
mentioned a line chart, but an #N/A label shouldn't appear in that type
of chart.