Access - Chart two columns of dates

L

Larry T.

Trying to create a bar chart showing a comparsion between to colums of dates.
Column 1 - Date Opened, column 2 - Date Closed.
Need to show number of items for each month. Run into a problem when there
is no items for a particular month. Chart allows one to use two sets of data
but only one column to define month. If I choose Date Opened and there is no
entry for January there is no tag for January on 'x' axes. Date Closed may
have items for January but there is still no label. Is there a way to show
each month and correct data in each month based on the two columns?
 
Top