ggplot2_ combining line and barplot in one graph

Question

Let's say I'm creating the grouped barplot by something like this:

data <- data.frame(time = factor(1:3), type = LETTERS[1:4], values = runif(24)*10)
ggplot(data, aes(x = type, y = values, fill = time)) +
  stat_summary(fun=mean, geom='bar', width=0.55, size = 1, position=position_dodge(0.75))

Inside each type I want to connect all bar tops (meaning to connect 3 bars for A, 3 bars for B, and so on) with the line. I'd like to get something like that as a result:

Is there a way to do that ? Thank you!

Vinícius Félix · Accepted Answer · 2022-12-23 20:58:17Z

1

I changed the code to another logic that I prefer, that is to prepare the data before using ggplot().

Code

library(dplyr)
library(ggplot2)

data <- data.frame(time = factor(1:3), type = LETTERS[1:4], values = runif(24)*10)

pdata <- data %>% group_by(type,time) %>% summarise(values = mean(values,na.rm = TRUE)) %>% ungroup()

pdata %>% 
  ggplot(aes(x = type, y = values)) +
  geom_col(
    mapping = aes(fill = time, group = time),
    width = 0.55,
    size = 1,
    position = position_dodge(0.75)
  )+
  geom_line(
    mapping = aes(group = type),
    size = 1,
    position = position_dodge2(.75)
  )

Output

edited Dec 23, 2022 at 20:58

answered Dec 20, 2022 at 0:02

Vinícius Félix

8,8966 gold badges18 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Eugene Over a year ago

Thank you very much, Vinicius! I actually meant to connect 3 bars inside one type. Meaning, mean values for red, green and blue bars with one line in A, another similar line for B, then one for C and one for D. Is it possible ? Thank you!

Eugene Over a year ago

I guess the difficulty here is that x parameter is needed to create line across x coordinates. And here it's required to create the line "inside" one coordinate (like for all bars inside A coordinate)

Vinícius Félix Over a year ago

Sorry I did not understand how is your desired output? Can you maybe draw something?

Eugene Over a year ago

Thank you, Vinicius! Yep, please, see the example picture in the question. Thanks a lot !

Vinícius Félix Over a year ago

Now I got it, I updated my code

Collectives™ on Stack Overflow

ggplot2_ combining line and barplot in one graph

1 Answer 1

Code

Output

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Code

Output

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related