Glitch when making scatter plots HELP

Ran into an issue where excel doesn't allow me to create a proper scatter plot. Following selection of a range of x values, excel does not allow me to select my own range of y values, instead it assigns its own step in accordance to the amount of cells occupied. The same applied when i select y values first, it then, doesnt allow me to select x values.

I tried to repair office suite following a reinstallation, to no avail.