View original (French)

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

doucha -  
tontong Posted messages 2575 Registration date   Status Member Last intervention   -
Hello,
I want to put text on the x-axis of a scatter plot
Can someone help me? please

Configuration: Windows 7 / Chrome 34.0.1847.137

3 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    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.
    3
  2. lesoldatbleu2 Posted messages 3 Registration date   Status Member Last intervention  
     
    Hello

    A bullet point text? A title?
    0