Here's how I would set up these dynamic ranges.
First, I'd make one for the x axis or dates
Dates = OFFSET($D$4,0, MAX(0,MATCH(TODAY(), $D$4:$ZZ$4)-12),0,12)MATCH(TODAY(),D4:ZZ4) finds the last date less than todays date which would be your theoretical end of data point
The Max(0, Match...) is in case you have less than 12 columns of data
The others can be based off that series so you don't need to re-invent the wheel. For example, Mobile New is 9 rows below Dates
Mobile_New = OFFSET(Dates, 9,0)
and so on.
Bookmarks