I have attached a worksheet where I have attempted to create a dynamic rolling chart showing the last x number of days (input by user in cell Q3). I based it off this website which I have seen referenced in this forum http://peltiertech.com/Excel/Charts/DynamicLast12.html
I have created the report in excel 2010 but the users are on excel 2003 so I am saving as 2003. I have also only just upgraded to 2010 so am struggling with charting in this version.
It is working well except for 3 problems:
1 - The last date in the data range is not showing on the charts
2 - I don't seem to be able to prepopulate the full year of dates in column R. If I do that, it always gives me the last 60 days from 31dec2012 (e.g. blank data). This means that the user has to drag down the date each day when they enter the data in columns S-X. Not a major deal but just wondering if there is a way to avoid that.
3 - Ideally, I would like to allow the user to filter out weekends. This is easy in 2010 but, in 2003, the filtering is too limiting. I have therefore hidden the weekends and the user would have to go to tools>options to show them for each of the 6 charts. Not very user friendly. Is there a better way in 2003?
Any help would be greatly appreciated.
Bookmarks