How do I use geom_bar correctly with two rows of the same name?

Question

I have this data set and want to make a geom_bar similar to the one I provided.

I want the geom_bar plot to have each one of the rows with the same name as different colors. Similar to this:

Answer 1

Maybe you are looking for this. You have multiple values for the number of counts. So you can group by NumAccounts and create a reference variable so that each value can be plotted in a bar. For that you can use mutate() from dplyr and group_by() in order to have such id variable. Then the plot can be designed (Please next time include a sample of your data using dput()). Here the code:

library(ggplot2)
library(dplyr)
#Data
df <- data.frame(NumAccounts=c(1,2,3,1,2,3),
                 MeanNumAccounts=c(73.36,64.74,431.5,340.98,226.14,693))
#Mutate group
df %>% group_by(NumAccounts) %>% mutate(ID=1:n()) %>%
  ggplot(aes(x=factor(NumAccounts),y=MeanNumAccounts,
              fill=factor(NumAccounts),group=factor(ID)))+
  geom_bar(stat = 'identity',color='black',position = position_dodge(0.9))

Output:

And a more customized solution would be:

#Code 2
df %>% group_by(NumAccounts) %>% mutate(ID=1:n()) %>%
  ggplot(aes(x=factor(NumAccounts),y=MeanNumAccounts,
              fill=factor(NumAccounts),group=factor(ID)))+
  geom_bar(stat = 'identity',position = position_dodge(0.9))+
  labs(fill = 'NumAccounts',x='NumAccounts') 

Output: