Re: Problem with chart

Thanks but that leaves #N/A in the cells.

So I have added conditional formatting = error with a white text and that achieves what I wanted

Thanks again