Here's a copy of a reply I posted to a similar question about a week ago.
It refers to years, rather than months, but the principle is the same. See
if this helps, and post again if you need more info.
To get all years to display on the graph, you must have them in the
recordset for the graph - ie. in your query. You don't give any details of
what this query is, but here's a couple of suggestions.
If your query is a crosstab, you can force the years into the query by
including an IN clause after the PIVOT clause; something like:
... PIVOT MyYear IN (1997, 1998, 1999, ....)
If you're working in the query design grid, show the query property sheet
and enter the values in the Column Headings field.
If it's not a crosstab query, you'll need to add a year field by some other
method, such as a table (tblYears) containing a single field, YearsToShow,
and populated with the years you want. Add this table to your query, and
join the YearToShow field to your year field (which I'm guessing is a
calculated field from the date value). Click on the join, and select the
option to show all values from tblYears and only those records from your
existing table where the fields are equal. This should give you a recordset
with all years, but only values in the fields to be plotted for those with
data.
HTH,
Rob
