Hey Mr.excel 
I work on a project, and this project contains alot of charts. We have 4 sheets with data and each sheet has a chart showing the over all progress, and then a chart showing the lastest 3 day progress. My question is:
- Is it possible to make a macro thats update the 3 day progress chart, so it always shows the lastest days and not just extent the chart to 4 days and so on??
An exp on my charts
Hope you can help me :D

I work on a project, and this project contains alot of charts. We have 4 sheets with data and each sheet has a chart showing the over all progress, and then a chart showing the lastest 3 day progress. My question is:
- Is it possible to make a macro thats update the 3 day progress chart, so it always shows the lastest days and not just extent the chart to 4 days and so on??
An exp on my charts

Hope you can help me :D