I currently have a whole table of data imported into Excel from Access. The only problem is, i cannot seem to import the data for the previous year using a query. With the data i would like to create a chart for the past 12 month, i.e the last 12 cells (as the data is taken monthly). Can i select data for the last 12 months that will remain the last 12 months even when the worksheet is refreshed every month?

How my data looks:
Date % Acknowledged % Investigated
09/2005 85 99
10/2005 90 85