Updateing graphs

**4lowie** · 12-08-2013, 09:08 AM

Hi all
New here as I can't figure out the last part of my spread sheet and need help!!
I've got a spread sheet which tracks data that's refreshed everyday to build the graph trend. I load the data into sheet1 and the calcs are then represented in the next sheet which has the graphs. At the moment I have to copy and paste the results into the cells that build the graphs. How do I have this done automatically? If I link to the data spread sheet I can only show one days result, I need to build my graph as the days go by. Any idea's? The only other thing I'd like to do is have the graph data only show the previous 30 days data, just have the oldest "roll off" at the start of the graph as new data is added.

I'd appreciate some help on this please.

Many thanks, Dave

**Bhuvi** · 12-08-2013, 09:56 AM

Hi, could you please upload a workbook for example.

**4lowie** · 12-08-2013, 10:12 AM

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