Updateing graphs

Thanks for the reply.
As you'll see on the right side of the Graphs tab there are 7 cells that contain data carried over from Sheet1. T3:T9. At the moment I have to copy this data into the appropriate cells each day to build the graphs. The data in Sheet1 is replaced everyday. It would be good to automatically copy this data to the date cells, this would fully automate the process. The only other thing i would like is for the graphs to show the last 30 days of data, just drop off the first entry when a new set of data is loaded.

I know this would be possible but the question is how much effort is required??? I know it's beyond me but if anyone is willing to help I'd be most grateful.

Thanks Dave

Anyone got any idea's?

Thanks