Producing 7 days worth of data

[Ash_]

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

[FDibbins]

Create a small table that will contain your data, have a start (or end) date at the top of the table, then (obviously depending on how your data looks) use a vlookup() for the start date, then start date +1, start date +2 etc (or reversed - end date, ED -1, -2 etc)

[Ash_]

Good shout!

Thanks very much, something so simple eh :P

[FDibbins]

Happy to help and thanks for the feedback