In a chart if you display data labels is there a way of avoiding a zero being displayed if the relevant cell is the result of a formula? It seems that even if the result of that formula is a blank or 'n/a' it is still displayed as 0. Thanks. Steve