Hi Nick,

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.

Cool!

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 supposed to show all the points all the time, and automatically include
any new points added to the data file, refreshing every minute. I thought that
was what you wanted?

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

Only by using VBA, I'm afraid, setting an OnTime routine to keep refreshing
quicker than the one-minute interval. Searching google for OnTime (and maybe
"flashing text") will probably return some code you can use.

Regards

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