View original (French)

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

Nat_697569 Posted messages 2 Status Membre -  
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur 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 réponses

Réponse 1 / 4
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
Select the data table A8:B13 instead of 
B1:B6
!

Retirement is nice! Especially in the Caribbean...
Raymond (INSA, AFPA)
0
Réponse 2 / 4
Nat_697569 Posted messages 2 Status Membre
 
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
Réponse 3 / 4
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello to both of you

A solution
https://mon-partage.fr/f/pyrYQuEo/

Raymond will recognize his little ones ;-)

Best regards
0
Réponse 4 / 4
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
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