ggplot group mean line

Question

Trying to add a mean line for each group to bar chart. Receive same error each time:

Error in FUN(X[[i]], ...) : object 'Count' not found


ggplot(df_melted2  %>% 
         filter(EDNAME =='Blanchardstown-Corduff'), aes(Resource, Count, fill=Resource)) + 
  geom_bar(stat="identity", position = position_dodge()) +
  facet_wrap(~ EDNAME, scales = "free") +
  coord_flip() +
  theme(panel.background = element_blank())  +
  geom_point(data = df_melted2 %>% 
               group_by(Resource) %>% 
               summarise(Mean_Resource = mean(Count)))

It works fine without the attempt to add the mean line:

ggplot(df_melted2  %>% 
         filter(EDNAME =='Blanchardstown-Corduff'), aes(Resource, Count, fill=Resource)) + 
  geom_bar(stat="identity", position = position_dodge()) +
  facet_wrap(~ EDNAME, scales = "free") +
  coord_flip() +
  theme(panel.background = element_blank())

Why is it not recognizing the column 'Count' and how did I get overall group mean lines in the chart?

Please dput(head(df_melted2 ,30)) and paste the result in the question. — Duck
– Duck, Commented Aug 6, 2020 at 19:48

Rtab · Accepted Answer · 2020-08-06 20:01:36Z

1

Major oversight on my part. The summarized column must be the same name as the original and I had given it a new name.

ggplot(df_melted2  %>% 
         filter(EDNAME =='Blanchardstown-Corduff'), aes(Resource, Count, fill=Resource)) + 
  geom_bar(stat="identity", position = position_dodge()) +
  facet_wrap(~ EDNAME, scales = "free") +
  coord_flip() +
  theme(panel.background = element_blank())  +
  geom_point(data = df_melted2 %>% 
               group_by(Resource) %>% 
               summarise(***Count*** = mean(Count)))

answered Aug 6, 2020 at 20:01

Rtab

12310 bronze badges

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

Collectives™ on Stack Overflow

ggplot group mean line

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related