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