I have a large amount of sales data (forecast and actual) which updates automatically via TM1 (IBM cognos) everyday. I would like to keep tabs on this sales data in excel by showing 3 months prior to todays date, and 3 months into the future. However, in a months time if I come to update the graphs, I would like excel to automatically adjust the timeline so it is looking at the 3 months before and after that particular date.. In other words, I would like the 6 months (past and present) to move forward a day, every day. Sorry if that is difficult to follow, but I'm pulling my hair out trying to work this out. Some help would be greatly appreciated!!