I have a table that looks as follows:

I want to make a bar plot where each bar takes the data in column one('family') as the label and stacks the data in columns two and three for each bar. Say the datapoints from column two make up the primary data show in the bars and the data from the third column is overlaid over it.

I am trying to do this in ggplot.

I have tried the following approach (as taken from

Not sure if the code in the linked post is outdated or if I am doing something wrong.

I see some random webpages here

Another option (rather than mixing stats) would be to use facet_wrap, so that you mean in one graph and max in another:

df2 %>%
  pivot_longer(-family) %>%
  ggplot(aes(x = family, y = value))  
  geom_col(position = position_stack())  
  scale_y_continuous(breaks = seq(0, 1400, 200),
                     limits = c(0, 1400))  
  facet_wrap( ~ name, scales = "free_y")  
  theme(axis.text.x = element_text(angle = 90))