Hi all -
I am trying to create a dynamic rolling 12 month chart. My data set gets added to each week and I want to view a 12 month snapshot without having to always update the range.
I believe the offset function is likely my best bet but i'm not sure how to make it work for me. Currently, my formula is:
='Raw Data'!$A$1,'Raw Data'!$LY$1:$OB$1,'Raw Data'!$A$3:$A$6,'Raw Data'!$LY$3:$OB$6
Translation:
A1-A6 is my Legend
LY1:OB1 is my date range on the horizontal axis
LY3:OB6 is my data that is populating on the vertical axis.
I need both the horizontal and vertical axis to add the most recent data and remove 1 week each time I update this so I only get the annual snapshot. My date increments by week, not day or month.
Any help would be appreciated.
Bookmarks