use macro for multiple plots

[drogones12]

Hi,

I like to create a macro to make 3 axis plots for this wastewater data. The plots will have column A on X axis, column B on Y1 axis(left vertical axis) always. The column C to the end column will be the changing Y2 axis(right vertical axis). Basically, only data on Y2 axis changes throughout the plots. All input will be appreciated.