Dynamic Charts

[surkdidat]

I have the following formula -

=OFFSET(Sheet1!!$B$1,COUNTA(Sheet1!!$B:$B)-Sheet1!!$D$2,0,Sheet1!$D$2,1)

- however, this looks at the bottom of my data, and takes it from there... What I am after is for this to take it from the top (excluding headers, so row 2 downwards) -

COLUMN A is date
COLUMN B is data
COLUMN D is the number of rows of data I want returned. So if I have entered "5" in D2, at present it goes to the bottom of my data sheet, and generates the table/graph from that.... I need it to be rows 2,3,4,5 and 6 (based on 5 returns)...

Due to the data in the table I cannot simply flip the data around......

Thanks, as ever, to everyone in advance

 

[Fluff]

How about

=OFFSET(Sheet1!!$B$2,0,0,Sheet1!$D$2,1)

 

[surkdidat]

How about

=OFFSET(Sheet1!!$B$2,0,0,Sheet1!$D$2,1)

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.