Hi,
I recently devised a allocation tool using excel 2010 for my work which helps us allocate workloads as they come in. I use graphs to show how much work is coming in from different areas to make it fair.

Is there a way or a method where by everytime the spreadsheet is opened or even say 2/3 times a week the data from the graphs can be recored? I want to look at the data over month periods to see the trends and this way I can see if workloads are dropping off or increasing in terms if inoput from clients.

i don't know where to start!

Thank you