Hi All
I've used the link to create a rolling chart which works well for data that runs down the columns.
I've tried to create the same thing for data running across the columns as well but it isn't working so well, it doesn't auto update unless I highlight the whole range & then drag in another period, then it's fine.
I'm also finding that if I delete periods of data, it will revert to just a few days instead of the entire range that's still left??
The Defined name I've added for the Totals is below:
=OFFSET(autochart!$B$58,0,0,,COUNTA(autochart!$B$58:$IV$58))
The date defined name is the same apart from the row it reads:
=OFFSET(autochart!$B$57,0,0,,COUNTA(autochart!$B$57:IV$57))
I've changed the Range to read from the entire column 'A' to be the entire row from Column 'B' to Column 'IV'
Can anyone advised where this is wrong? It's sort of half working but I'm unsure what's wrong???