View original (French)

Excel chart with "stacked" y-axis and words on the x-axis

Nat_697569 Posted messages 2 Status Member -  
Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   -
Hello,
I would like to create a chart with names on the x-axis and one or more numbers on the y-axis. I can create this type of chart when the x-axis is made up of integer numbers, and I would like to achieve the same result by replacing the integer numbers with words.
Thank you for your help!

4 answers

  1.
    Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 491
     
    Select the data table A8:B13 instead of 
    B1:B6
    !

    Retirement is nice! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
  2. Nat_697569 Posted messages 2 Status Member
     
    Yes, of course, that's what I did, but it doesn't give me the result I am looking for (sorry, I should have started with that).
    0
  4. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 491
     
    Hello.

    You didn't specify that it was a scatter plot...
    A scatter plot is a combination of numbers on the x-axis and numbers on the y-axis. 
    You cannot have both a scatter plot and names on the x-axis
    .
    I advise you to choose another type of graph, histogram or curves; but not pie, stock, or radar!

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0