Move Or Scroll Chart

i've a little problem @ work. Each morning i've to insert some data of the day before and update 2 chart with some series moving the seriescollection frome 5 days before to the data that i've inserted in that moment. I'm trying to do a macro that do automatically that "seriescollection shift" to avoid to do that manually for each seriescollection of each chart each morning. I mean (maybe i've been not very clear) i usually click on the chart series, then i can see the range data source and using the mouse i move this range 1 column in plus on the right mantaining width.