A single scatter plot from multiple XY (100+) series

[NMBh]

Hi, I'm new to the forum and looking for help with a scatter plot. I have 100+ series to add in a single scatter plot. adding them one at a time manually will take lot of time. Any quick help would be highly appreciable. I have attached the excel sheet and a sample graph. I would like to add rest of the series to the same graph.
many thanks

[Kaper]

Requested graph is "not-very-typical" for Excel, because for each series, you use different Yvalues and Xvalues. (standard is different Y values but for the same set of eXes).

I'd do this with simple macro.

I recorded a macro while adding second series (column C data), and it was like this:

Please Login or Register  to view this content.

So I used it to create a macro to add all series (just added a loop to tyhe recorded one and used loop's counter to get propper addresses).
So having a graph with one series (column B data) ready and selected, run such a macro:

Please Login or Register  to view this content.