Hello Guys
I have a table which consists of column A (Date) and column C (Quantity).
This table has values automatically added to it every day upon a macro with the opening of the file. For example 20/05/14 in column A and 6457 in column C.
The data on this table will keep growing, will not get deleted. What I would like to do is create a chart/graph which shows only the data for the last 7 days. So 14/05/2014 - 20/05/2014.
Cant work out how to achieve this.
Any help is greatly appriciated!
Kind Regards
Ash
Bookmarks