My data have 2 numerical columns (positive and negative values) and 2 categorical variables. Now I want to plot negative and positive bars on same line, instead of positives ones under negatives through this code by keeping all the rest setting the same?

df <- data.frame(model  = c("A","B","C","D","B","C"),
                  category = c("origin", "origin","origin","abroad","abroad","abroad"),
                 pos = c(40,50,45,100,105,80),
                 neg = c(-10,-5,-4,-16,-7,-2),
                 Colour = c("chocolate","deeppink4","yellow","steelblue3","deeppink4","yellow"))

Colour <- as.character(df$Colour)
Colour <- c(Colour,"white")
names(Colour) <- c(as.character(df$model),"white")



df <- df %>% pivot_longer(., cols=c('pos','neg'),
                           names_to = 'sign') %>% 
  mutate(Groups = paste(category, model),
         sign = factor(sign, levels = c("neg", "pos")))



bar2 <- ggplot(df, aes(value, tidytext::reorder_within(model, value, category),
                fill = ifelse(sign == "neg", "white", model), 
                color = model)) 
  geom_col(position = "dodge")  
  scale_fill_manual(values = Colour, breaks = df$model)  
  scale_color_manual(values = Colour, breaks = df$model)  
  tidytext::scale_y_reordered()  
  labs(fill = "model")  
  facet_grid(category ~ ., switch = "y",scales = "free_y")  
  theme(axis.text.x = element_text(angle = 90),
        strip.background = element_rect(fill = "white"),
        strip.placement = "outside",
        strip.text.y.left = element_text(angle = 0),
        panel.spacing = unit(0, "lines")) theme(legend.position="none")   
        labs( title = "BarPlot",
              subtitle = "changes",
              y = " ") 

bar2

CodePudding user response：

Change "dodge" to "stack" in

geom_col(position = "stack")