Named Range Dynamic Chart Formula

[soood]

I want to show the last 10 data points rather than all, the formula below will show the last 10 when the data is vertical, what would the formula be if the data was horizontal?

=OFFSET(Sheet1!$A$1,COUNTA($A:$A)-10,0,10)


For example...
If my x data was in A1:Z1
and my y data was in A2:Z2


Thanks

 

[JimM]

Try

=OFFSET(Sheet1!$A$1,0,COUNTA($A$1:$Z$1)-10,0,10)

 

[soood]

Thanks but your formula does not work.