I have several KPI's that are monitored monthly on a rolling year. I can set up charts quite easily for this, but then each month when i want to roll the data forward a month, i have to manually go in and change the series cell reference. I wondered if anyone could suggest a more simple/automated way of doing this? Thanks
Bookmarks