How do I plot two variables onto one graph using ggplot2?

Question

You can create the data set using:

 structure(list(month = structure(c(5L, 4L, 8L, 1L, 9L, 7L, 6L, 2L, 12L, 11L, 10L, 3L, 5L, 4L,8L, 1L, 9L, 7L, 6L, 2L, 12L, 11L, 10L, 3L),.Label = c("Apr", "Aug", "Dec", "Feb", "Jan", "Jul", "Jun", "Mar", "May", "Nov", "Oct", "Sep"), class = "factor"), 
variable = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 
1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L
), .Label = c("npop", "temp"), class = "factor"), value = c(220, 
180, 150, 250, 270, 300, 500, 580, 580, 1000, 380, 100, 15, 
17, 20, 24, 26, 28, 30, 31, 30, 28, 19, 16)), row.names = c(NA, -24L), class = "data.frame")

Once created I intend to plot "temp" and "npop" both with respect to the month by using ggplot2 and the code:

p<-ggplot(data=df,aes(x=factor(month,level=level_order), y=value))+xlab("Month")+ylab("value")+geom_bar(stat="identity")

However the error I recieve is "Error in FUN(X[[i]],...) : object 'value' not found.

Is this to do with the fact that I am including a level in my argument? This is necessary because ggplot2 lists the months in alphabetical order, so I created a seperate object which is:

level_order<-c("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

Any help is greatly appreciated!

Are you sure you're using the right dataset in reality? Seems that there's no value column, or it has a different name (capital "V"? something else?) — AntoniosK
– AntoniosK, Commented Feb 4, 2020 at 13:56
...also the code as it is plots the aggregated counts and not a split between npop and temp. — AntoniosK
– AntoniosK, Commented Feb 4, 2020 at 13:59
I've figured it out, my argument for data was "df" for my previous plot and not "df2" — OpenSauce
– OpenSauce, Commented Feb 4, 2020 at 14:09

anddt · Accepted Answer · 2020-02-04 15:46:57Z

1

You can plot multiple variables in the same geom_bar() plot using the fill attribute (after having converted your data in long format) in the plot aesthetics and using position = "dodge" to get the bars side by side:

df %>% 
  ggplot(aes(month, value, fill = variable)) +
  geom_bar(stat='identity', position = "dodge")

Which outputs the following plot:

Your variables seem to lie on pretty different scales, I would either add a secondary axis or scale the variables

edited Feb 4, 2020 at 15:46

answered Feb 4, 2020 at 14:15

anddt

1,6811 gold badge12 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

How do I plot two variables onto one graph using ggplot2?

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