Dear Amanda Godtkjaer,
Good day! Thank you for posting to Microsoft Community. We are happy to help you.
Generally, we change the text direction of the vertical axis in a "Format Axis" in the dialog box, as like shown in below screenshot:
As per your description, can I know does in your data sheet the Text (Question 1, question 2 and Brian and Kate) are in separate column cell? If yes, then you need to first combine text into one column cell or putt Text in one column then create a bar chart and change the text direction of the vertical axis of bar chart in a "Format Axis" in the dialog box, as like shown in below screenshot:
Appreciate your patience and understanding and thank you for your time and cooperation.
Sincerely,
Waqas Muhammad