I am supposed to be doing a scatter plot for a paper but I can't figure out how to plot the scatter graph in Excel and as much as I've googled it nothing has come up that's telling me what I need. I need to use the vertical axis for the price and the horizontal axis for the time. The years (time) are 2014-2016. The prices vary but I used two sets (beginning year and end year). The prices are:

2014:

B: 33.03

E: 49.38

2015:

B: 49.35

E: 54.36

2016:

B: 53.09

E: 56.36

2017:

B: 58.94

E: 53.62

I've unsuccessfully been trying to plot this for a few hours and nothing comes up the way I think it should. The vertical axis doesn't come up as just price and the horizontal definitely doesn't come up as time.