Craig, I assume that this year's values and last year's values are all in
the one table (which is the right design.) Since you want 2 different
results for two different periods from the same table, use a subquery to get
last year's results and match them to this one.
If subqueries are new, see:
Subquery basics: Year to date
The article discusses what subqueries are, and demonstrates how to make a
year-to-date query. You can do a period-compared-to-last-year in the same
Once you have the query, you can use it as the source for one of the chart
types that handles multiple domains.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.