How to create a scatter plot with text on the x-axis?

Hello,
The graduations on the x-axis of a scatter plot are proportional to numbers; they must necessarily be numbers.
However, you can choose not to display these labels: Axis format >> labels >> none.

You can add text boxes, but be careful to select the chart first; otherwise, the boxes will be linked to the sheet and will not move with the chart.
You can link the text to a cell:
The text is contained in C2
Type = in the formula bar, then click on cell C2. It will display =sheet1!C2. Confirm. It will display =sheet1!$C$2.
The text contained in C2 will appear. This text is dynamic: the chart updates with C2.
Repeat the operation for the other points.

You can go even further by creating a series on the axis: all y = 0.
Let us know if you want to go that far.