3 answers
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.
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.
Hello
You will probably need to go through a macro
an example
https://www.cjoint.com/?3ExlDv3N6ZP
Best regards
You will probably need to go through a macro
an example
https://www.cjoint.com/?3ExlDv3N6ZP
Best regards