macro to plot connected scatter plots

hi,
i have a date/time column and then multiple columns with my data sets. I want to write a macro that will automatically do scatter plot as soon as i place my data into those range of column.

Thank you

Some example, please ... the data does not have to be true.