Trend analysis

Hi,

I was wondering if someone could please help,

The attached is a file that we produce on a weekly basis, we fill out the 'Control Temperature' and 'Test Instrument Temperature' columns. I have been tasked with poducing trend analysis charts/graphs for ease of reading. I need to be able to link the individual cells in the 'Furnace' column to a chart that will update on a weekly basis. Is there anyway that a VBA can be written that will move the information from the completed file to another file that updates graphically ? Is that confusing ?