Charts - Changing Data Range (Modify Range)
Hi, I have a Dashboard with about 12 charts from one sheet. It looks at five years of data. In 6 months I'm going to want to change that five year period. Is there any method I can employ to make that happen automatically or will I need to reselect the data on each chart for the new time period?
I'll be adding the new year to the existing columns. The oldest year data will remain but will need it to drop off the chart and pick up the latest year data (running 5 years).