I have a spreadsheet that calculates the cell reference relating to 2 dates entered into cells V6 and V7. For example where: V6 contains 26/4/2004 and V7 contains 30/8/2004. Then cell W6 and W7 would contain cell reference I15 and 015 respectively. Cell Z6 then contains a concatenated formulae that displays: for example: "=average(o15:AA15)

Is there a way to take this concatenated formulae and put into another cell so that a graph plots on this range ?

Let me know if I need to explain further. Is it something like an INDIRECT function that I need to use. Help please.

Thanks

Scott.