6 month moving timeline - excel

Microsoft Office excel 2007 - upgrade
January 25, 2011 at 06:04:12
Specs: Windows 7

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!!

Regards, James.

See More: 6 month moving timeline - excel

January 25, 2011 at 21:49:56
It's not clear to me what you are trying to do. Are you looking to hide rows or columns based on a selected cell? Are you trying to change the source data for a chart?

Please clarify what you are trying to do, perhaps including some example data if you think that will help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question