Reorder bars in ggplot2 according to one of the fill variables (Fill)

Question

Hello,

I have a graph that shows the proportion of equipment available in schools of Pernambuco, and I would like to order it from the equipment with greater presence (greater has) to those with lower presence:

Currently my code is like this:

df %>%
  ggplot(aes(x=equipamento ,y=perc, fill=situacao), arrange(situacao)) +
  geom_col() +
  ggtitle("Percentual de creches que atendem aos parâmetros do CAQi") + 
  theme_bw() + theme(axis.text.x = element_text(angle = 45, hjust = 1))

Given the layout of my data, I do not know if it is possible to reorder using factor:

I appreciate the help!

Answer 1

Why not use fct_reorder2? With this, you can sort the two variables preferably.

df %>%
 mutate(equipamento = fct_reorder2(equipamento,situacao, perc)) %>%
  ggplot(aes(x=equipamento ,y=perc, fill=situacao), arrange(situacao)) +
  geom_col() +
  ggtitle("Percentual de creches que atendem aos parâmetros do CAQi") + 
  theme_bw() + theme(axis.text.x = element_text(angle = 45, hjust = 1))

Answer 2

Use the fct_reorder function of the forcats package for this.

df %>%
  mutate(equipamento, = fct_reorder(equipamento, perc)) %>%
  ggplot(aes(x=equipamento ,y=perc, fill=situacao), arrange(situacao)) +
  geom_col() +
  ggtitle("Percentual de creches que atendem aos parâmetros do CAQi") + 
  theme_bw() + theme(axis.text.x = element_text(angle = 45, hjust = 1))