Hide empty (or NA) cells in a chart with a nod-date type axis

Hello

I'm trying to plot some values in a column chart.
The last values of the series are, at the moment, blank cells (the formula in them either returns "" or NA()).

The "axis-label" row has some text written (not dates)!

When I plot them into the chart I want those last empty values to be invisible untill there are some values in there.

How can I do this?

I'm not sure if i've been very clear about what I'm trying to do so I attached an example file.

Thank you for you support and sorry for my bad english.