I have created a data table, linked to Spin Buttons and based off an OFFSET formula =OFFSET('Data Offset'!C3, 'TREND Analysis'!$J$3,,), where the "Data Offset" workbook contains the data, the "TREND Analysis" workbook contains the dynamic charts.
The charts show the last 6-months worth of...