Excel Charts ignoring Zeros

Hi All

I am trying to produce a line chart for financial results for different organisations as part of a project

unfortunately not all the organisations have the same month as year end, some March and some December.

Is there a way of producing a line chart which would plot this 

Sample data 

I was hoping to produce something along the lines of

but using the chart function line graphs appear to not show any information

Sorry its probably a very simple answer i have missed

Thanks in advance