Hello all. I am trying to create data range used in chart that needs to be of fixed size but moving as we add rows to table.
So in the picture I have range of 3 rows
Range1.JPG
And as I add new data it should move down but remain height of 3 rows
Range2.JPG
I've been trying with OFFSET and COUNTA but getting error when using COUNTA as row reference in OFFSET command (I hope I am clear on this)
Bookmarks