Ranging dates for a graph

[patfee]

Hi,
I have a table containing 200 records which contains a "start_date" field and and "end_date" field. The 200 records are representing details of interventions done in the past.

I would like to develop a query showing counting the interventions done in January, Febr, ..., December for management reporting purposes.

I can manage to do this by developing a query showing different a count in 12 columns but this query can not be used as data for a graphs (bar-chart) as the columns are limited to 6 in total.

Any idea how i could manage differently?

Thanks
Patrick

 

[Tigerlili3]

Is the data really in columns or is it in rows? Also, why are the columns limited to 6? It is not a limitation imposed by Access. I currently have a graph in Access that contains more than 50 bars. Are the months going to be the x-axis or y-axis of your graph?