Scatter Plot question. It is easy but I can't figure

[bankerturnedconsultant]

Hi there! I am struggling to create a scatter plot

I want to create one scatter plot with 1980 and 2022 data for few countries.
X axis = % of GDP contribution
Y axis = $ GDP contribution

I want to show how the dot moves for UK from 1980 to 2022. So I want 2 dots for UK in the same colour and so on.

Is there a way to do this please?

This is my data:

	1980	1980	2022	2022
	% of GDP	$ contribution to GDP	% of GDP	$ contribution to GDP
UK	4.78​	67.44​	8.55​	244.67​
China	0​	0​	7.94​	1278​
Germany	7.27​	127.7​	4.16​	134.67​
Hong Kong	11.17​	4.85​		67.88​
Netherlands	7.22​	24.81​	6.98​	55.75​
Singapore	6​	1.93​	14.54​	52.17​
United States	4.73​	345.55​	7.55​	1578.24​