Dynamic Chart Range - last x rows AND previous x rows

[arcaidius]

I have a dynamic Chart that uses the last 12 cells in column using:

=OFFSET(Sheetname!$C$2,COUNT(Sheetname!$C:$C),0,-13,1)

This gets the last 12 months of data from column C. works great!

Is there a formula that I can get the previous 12 months? so I can make another chart that compares both years?

 

[arcaidius]

Answered it myself, By getting the row number from previous formula in another cell, and then in one more cell with another Offset by itself.:
If any of you have the same Question, here is how i did it below:

This formula gets the last 12 rows in a column and updates with new entries: (I have in Cell Q3)

=OFFSET(Sheetname!$C$2,COUNT(Sheetname!$C:$C),0,-13,1)

This one gets the beggining row number from that formula (-2 rows) (I had this in cell P40 to test it)

=MATCH([COLOR=rgb(226, 80, 65)]Q3[/COLOR],A:A,0)-2

This one gets the previous 12 months data:

=OFFSET($A$1,[COLOR=rgb(41, 105, 176)]P40[/COLOR],0,-12,1)