I am new to using quary inputs and my quary is from multiple columns and I need to be able to graph that data. the problem is that it refreshes each minute and does not keep the old data to be able to create a graph. I am graphing live data. Can anyone help here? I am pretty lost but found some logical direction from http://www.excelforum.com/excel-prog...refreshes.html but am still lost with multiple columns. Thanks.