G Guest Oct 27, 2004 #1 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??
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 Oct 29, 2004 #2 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/ _______
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/ _______
