259
Creating Advanced Charts
This formula always grabs 12 rows by 1 column. The trick is figuring out where to start the
selection in order to get the last 12 months.
You can figure out how many months are present in column A by using
=COUNTA(A:A).
When there are 36 months, you want to use the data A26:A37. This means you need to
move 25 rows down from a starting position of cell A1. Thus, the Some Number of Rows
argument would be
=COUNTA(A:A)-11.
To create a chart that shows the latest 12 months, you follow the steps in the
previous example except that in step 6, the formula for months should be
=OFFSET(Scroll!$A$1,COUNTA(Scroll!$A:$A)-11,0,12,1)