How to automatically create a chart with multiple series in Excel?

Question

I want to create a scatter chart in Excel with dots only. I want each dot to be one series. Example of my data looks like this:

Legend Series	X-axis	Y-axis
300	0.0139	0.049
301	0.0166	0.119
310	0.0137	0.012
311	0.0111	0.107

I have not found an easy way to do this without having to put in manually one row at a time by creating a new series, but I am asking if there is a way to do this automatically (or something close to that). Should I put my data in some special order? I have tried the "paste special" function, but it did not give me the correct outcome.

Can you please help me? Thanks in advance.

Answer 1

This is as close as I can get

best wishes

Answer 2

Thanks for all the help, this answer is sufficient.

Answer 3

Alternative method. Had to use Select Data\ Switch Rows & columns

best wishes.