Help with chart updating macro

[Xineq]

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