I used to make scatter plots where my first data column would be my y axis
and the second data column would be my x axis. I would make them and they
would be sideways. Then I would go into view source data or something and
manually type in the column letters I wanted for x and y.

Now I tried the same thing and got the same sideways graph. I tried the
button that said switch x and y, but that made a disaster where each point
had its own data series. I tried to edit the source data, but somehow Excel
kept switching it back every time I typed anything or just put in new random
letters. So I went ahead and moved the data columns so the x column was
first and made a new graph, but somehow Excel had decided that the graph was
going to be forever sideways. Please I am about to go insane if I haven't
already.