Chart Help

[Tansar]

Hi,
I have a chart that has figures/data and in one of the cells I need to put in N/A - this is treated like 0 (zero) and messes up the chart.

Any way of getting round this?

Thank you

 

[shades]

Howdy. One solution is to put

=NA()

But in the longer term, you have to decide whether it will always be this cell, or should you incorporate it into an IF formula and use it in all cells. That way, whenever the data changes, then the same effect will result.
________
Volcano vaporizer