Empty Cells & Charts

L

Leroy-P

How do I get data ranage with blank cell into a chart and have Charts to
treat Empty Cells as nothing (NULL) rather than as 0's??
 
J

Jon Peltier

Leroy -

This is not an empty cell:

=IF(A>B,"",A-B)

The cell contains "", which looks blank, but isn't. Replace "" with NA(), which puts
an ugly error in the cell, but is interpolated over by the chart. Hide the error
with conditional formatting, as explained by Deb Dalgleish:

http://contextures.com/xlCondFormat03.html#Errors

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top