making chart from query

[kowol]

I'd like to create the chart from the attached table.
But some part numbers don't have quantity in certain month.
So those month won't show up in the report as you can see from attached picture (May is missing).
is there a way to create the query so that it shows 0 for May?
I was going to use crosstab query but it won't work somehow.

Thanks

 

[JHB]

I've made a small sample for you how it can be done in the attached database, open the only form, and choose a number from the combobox.