Macro to create multiple graphs from single data set

[URod]

Hi,

I am looking to create multiple graphs from a single data set just changing the parameter on the Y-axis in each instance. The different parameters I want to graph are in adjacent columns so I just need the graph to move the source across one colum each time. Ie in the sheet I have attached Flow is on X-axis vs pH on Y-axis, I then need this to move across to alk,bicarb, clarity etc creating a new graph each time.

Any help would be very much appreciated.

Thanks

** Note ignore column A, its all at one site.