I am trying to do a dynamic chart, to capture movements in the last 12 months.
I am using the following formula
=OFFSET('Working Capital'!$B$1,COUNTA('Working Capital'!$B:$B)-12,0,12,1)
and it is not working.
I have attached the data if any one may tell me what am getting wrong.
Thank you.
Bookmarks