How do I color two different dataframes on one chart using ggplot?

Question

How do I color two data series different colors on the same plot?

I combined two different dataframes:

ages_test=c('<18','18-24','25-44','45-64','65+',"UNKNOWN")

values_test=c(411694,1313082,2301521,918416,41728,178)
df_test1=data.frame(ages_test,values_test)

values_test=c(134924,350794,612476,228237,10472,49)
df_test2=data.frame(ages_test,values_test)

df_combined = rbind(df_test1, df_test2)

Then I created this plot:

df_combined %>%
  ggplot(aes(x=ages_test, y=values_test), label=values_test) +
  geom_bar(stat='identity') +
  scale_y_continuous(breaks=scales::breaks_extended(n=10), labels=comma) +
  geom_text(hjust=.5, vjust=-1, size=3, aes(label=comma(values_test)))

This chart contains the two different data series and labels for each. I want one of them to be a different color so that I can differentiate between the two.

I tried adding fill=values_test to aes like so ggplot(aes(x=ages_test, y=values_test, label=values_test, fill=values_test)) but the resulting chart shows a color gradient:

However, I want only two different colors, one for each data series.

I've also tried using color=as.factor(values_test) but this yields 12 different colors, one for each age category in my combined dataframe.

Ronak Shah · Accepted Answer · 2020-11-13 01:09:09Z

3

Use dplyr::bind_rows to combine the two dataframe with unique ids. You can then use fill in aes to give them different colors.

library(ggplot2)
df_combined = dplyr::bind_rows(df_test1, df_test2, .id = 'id')

ggplot(df_combined, 
      aes(x=ages_test, y=values_test, fill = id), label=values_test) +
  geom_bar(stat='identity') +
  scale_y_continuous(breaks= scales::breaks_extended(n=10), 
                     labels=scales::comma) +
  geom_text(hjust=.5, vjust=-1, size=3, aes(label=scales::comma(values_test)))

answered Nov 13, 2020 at 1:09

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

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

7 Comments

IamWarmduscher Over a year ago

Thanks again! You helped me out yesterday as well: stackoverflow.com/questions/64796835/…

IamWarmduscher Over a year ago

How do I customize the colors? I tried adding the following + scale_color_manual(values=c('dark green','green')) but it didn't work.

Ronak Shah Over a year ago

Use scale_fill_manual : scale_fill_manual(values = c('dark green','green'))

IamWarmduscher Over a year ago

What resources did you use to learn R? I started about a week ago and I'm using different pieces of code to hack things together. It's not very efficient.

Ronak Shah Over a year ago

Lot of practice coding and lurking on stackoverflow has helped me learn R.

|

Collectives™ on Stack Overflow

How do I color two different dataframes on one chart using ggplot?

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related