yanclarechen
New Member
- Joined
- Aug 7, 2002
- Messages
- 17
I have an Excel spreadsheet set up to collect shipping data on weekly basis. I also set up a bar chart to show the weekly shipment graphically. But I only want 14 weeks'data to show up on my bar chart, ie. starting from the current week, count back 14 weeks and update the bar chart. Or in another word, every week when I add the previous week's shipment data to the spreadsheet, I want the chart to be automatically updated, with the lastest week's data bar being added and the oldest bar being deleted. Is there any function or VBA code can be use to achieve that?
my email address: yanclarechen@lucent.com
my email address: yanclarechen@lucent.com