How can I sort the y-axis in Ggplot?

Question

I have the below code:

library(ggplot2)
theme_set(theme_classic())

g <- ggplot(EYAnmut_3rdParty, aes(QuestionNumber))
g + geom_bar(aes(fill=stemmed), width = 0.5) + 
  theme(axis.text.x = element_text(angle=65, vjust=0.6)) + 
  labs(title="Histogram Plot")

Which provides this plot:

How can I sort the Questions in the Y-axis to be in ascending order (smallest to largest) ? At the moment, it looks very scrambled.

The structure of my dataframe looks like this:

I tried changing the structure of my QuestionNumber variable to factor but it doesn't work.

Please edit your question to remove image data. Add data using `dput` — NelsonGon, Jan 09 '19 at 18:28
The `y` axis is count. I assume you want to sort the `fill` axis — Jack Brookes, Jan 09 '19 at 18:32
The fill axis (which is "stemmed") is actually comprised of the values "Yes", "No" and "Maybe". I am thinking that sorting this would not be helpful. Please let me know if it's otherwise. — Dinesh, Jan 09 '19 at 18:33
@Dinesh use `dput(head(df,20))` to add data to your question. — NelsonGon, Jan 09 '19 at 18:38
@Nelson, I'm trying my best to add in dput(), but it's still slightly confusing me. — Dinesh, Jan 09 '19 at 18:53
When you run `dput(head(Data,20))`. Copy whatever it outputs and add that to your question. — NelsonGon, Jan 09 '19 at 18:54

score 1 · Answer 1 · edited Jan 09 '19 at 18:49

1

With no sample data, an illustration is made using the famous iris: It can be assumed that Species is question number.

library(tidyverse)

iris %>% 
  arrange(desc(Species), Sepal.Length) %>% 
  ggplot(aes(fct_rev(fct_infreq(Species)), Sepal.Length, fill=Species)) +
    geom_col() +
    labs(x="Species")

edited Jan 09 '19 at 18:49

OTStats

1,820
1
13
22

answered Jan 09 '19 at 18:35

NelsonGon

13,015
7
27
57

This is possibly another variant answer. I'll need to check on this. – Dinesh Jan 09 '19 at 18:50
You should add data to your question for a more precise answer. The logic is no different though. – NelsonGon Jan 09 '19 at 18:51

score 1 · Answer 2 · edited Jan 09 '19 at 18:56

1

Data$QuestionNumber <- ordered(Data$QuestionNumber, 
                                           levels = c("Q1", "Q2", "Q5", "Q6", "Q7","Q8","Q9","Q10","Q11","Q12","Q13","Q14", "Q15", "Q16", "Q17"))

This code worked for me. I re-ordered the column based on levels.

edited Jan 09 '19 at 18:56

pogibas

27,303
19
84
117

answered Jan 09 '19 at 18:53

Dinesh

654
2
9
31

How can I sort the y-axis in Ggplot?

2 Answers2