Example of OFFSET when data is stored in rows not columns

[tewellt]

I have been trying to find an example of the OFFSET formula for a dynamic range for data stored in rows and not columns. For example Date is stored in row A (A3:Z3) and Score stored in row B (B3:Z3). All I can find is examples of data in columns. What I am trying to accomplish is to create a dynamic chart that the user can manipulate to show the range of dates they are interested in viewing.

I had an example of the Offset where it took into account the fact that the data row will contuniune to grow as time goes by.

Any examples and/or quidance would be extremely helpful.

 

[JLGWhiz]

I have been trying to find an example of the OFFSET formula for a dynamic range for data stored in rows and not columns. For example Date is stored in row A (A3:Z3) and Score stored in row B (B3:Z3). All I can find is examples of data in columns. What I am trying to accomplish is to create a dynamic chart that the user can manipulate to show the range of dates they are interested in viewing.

I had an example of the Offset where it took into account the fact that the data row will contuniune to grow as time goes by.

Any examples and/or quidance would be extremely helpful.

Is something like this what you are looking for?

=OFFSET(B3,0,0,1,COUNTA(B3:Z3))