Hi All,
I am attempting to create a macro to add multiple series to a scatter chart. I have a range for both the X and Y Values (see attached).
At present, I have been manually adding series one by one to the chart, but I have roughly a hundred series to add so this could get tiresome.
I am fairly new to coding/VBA so your help would be much appreciated.

Cheers,
Matt

TEST.xlsx