Previous year data into chart
 

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


--
dietmarhannam
------------------------------------------------------------------------
dietmarhannam's Profile: http://www.excelforum.com/member.php...o&userid=29089
View this thread: http://www.excelforum.com/showthread...hreadid=488143