Clear empty cells

[cercle92]

Hi,

I have a chart with a year overview, but at the moment there are no values for april, mai, june,...
So I want to see only the dates with a cell value. The other cells with no value have a NA within their cel. How can I do this?

Thanks in advance!
Book1.xlsx

[Kaper]

see the solution used here: http://www.excelforum.com/excel-char...-in-graph.html

By the way - posting a workbook just as a container for a picture is a non-standard approach.