How can I sort a graph by alphabetical or number. As you see, it sorts by number of answers. I would like to sort it by 0, 1, 2, 3, 4, 5 and 6. Not like now 1, 0, 6, 5, 2, 4 and 3.
Dear @Jens-Design-Leadership-Community,
The easiest way is just to add a column and number each row as you want to have them in your chart. Then sort them to become 1, 2, 3, 4, 5, 6, 7
When all fine, you just hide this supporting column and you are good to go.
Thanks, that might do the trick. I just tried to manually add numbers in a new column and the sort using that column.
The thing is that I have over thousand of rows 
So I tried to to use a formula to add the numbers automatically with
SwitchIf(
thisRow.[What is your title?]="Other", "1"
)
That worked like a charm. Thanks
1 Like