How to make Excel Chart not to display empty cells?
Marko,
if you hide the row or column (depending on which way your data is oriented)
that contains the x-axis label and the "" value, then this will be omitted
from your chart.
If you know VBA, you could write a macro that scanned each cell in your plot
range and hid its row/column if the cell value equalled "", and a
corresponding macro to unhide all rows afterwards.
Hope this helps
pete
"Marko Pinteric" wrote:
I have a range of IF formulas. Sometime IF returns number, sometimes
"". The problem is that chart displays "" as value 0. Is there a way
to force chart not to display those empty values?
IF(condition; number_value; "")
Marko
|