Hi Nick,

Sorry about this Stephen. OK then, I have created a scatter graph to plot the
columns against each other. I click on the points until they were all
highlighted. I then put that formula in.

Great!

Problem is though, all of the points are shown. It does not show you the
first point and then after a minute or so, show you the next point and so on.
Is it supposed to???

No it's not. It's supposed to plot all the points, updating every minute to
automatically include new data being written to the file.

Also, is there any way of getting Excel to refresh in less than a minute as
I tried to input 0.25 and it wouldnt have it because it only accepts integers

Not without VBA. You would need a routine to repeatedly refresh the query table
(ActiveSheet.QueryTables(1).Refresh), which can be done either in a continuous
loop (with maybe Application.Wait in it to pause things), or by chaining
Application.OnTime routines (search google for 'flashing cells' for some
examples of the latter).

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk