XY Scatter plot with multiple series issues / easier way to set it up?

Hi there,

I am working with a rather large set of data and am trying to figure out the best way to make a scatter chart with all of my data, along with having the each as a new series, thus being able to have indvidual labels in the legend.

An example of the data is --









With the corresponding XY scatter plot as so



Is there an easy way to have multiple series in a plot, without having to do it manually?

Sorry if this isnt clear, just ran into this issue and am going brain dead - yay for data analysis!

In Excel 2013 and later you can, I think, do something like this (I only have Excel 2010), https://support.office.com/en-gb/ar...ef87c6-485c-4fb4-a00b-80f3036ff777#bkmk_field
Also see: https://www.youtube.com/watch?v=4y9uO7MmNq0
In the attached there are two things that may be of interest, especially if you have Excel 2010 or earlier.
The first is a way of changing the data labels on an xy scatter chart, the second, perhaps closer to what you want, a way to create multiple series quickly.