I have a production database that all production is recorded on

 

I have to chart the weekly production by brand.

Some brands are slow runners and we do not make them every week,   

 

I have grouped the data by brand and then by week but the weeks with no production don't appear on the chart.

Is there a way to display the weeks with no production on the same graph.

 

Cheers