Error: stat_count() can only have an x or y aesthetic

Question

I am getting Error: stat_count() can only have an x or y aesthetic. when trying to plot using data from an excel sheet

library(readxl)
library(dplyr)
library(ggplot2)
dataset= read_excel("D:/Downloads/Covid19.xlsx")
dataset2= read_excel("D:/Downloads/Covid19.xlsx", sheet = "Sheet2")
dataset3= dataset[,c(4,5)]
ggplot(dataset2, aes(x=Region, y= male))+geom_bar()

My Data from excel file looks like this Dataset

Excel

what if i wanted to add male and female values both inside the graph? @sahwahn — Jijoy, Apr 06 '20 at 20:10
you'd need to reformat the data into long format - this should explain it https://www.r-graph-gallery.com/48-grouped-barplot-with-ggplot2.html — user438383, Apr 06 '20 at 20:12
@sahwahn is there a simple easy way for an beginner? it went all bouncer for me — Jijoy, Apr 06 '20 at 20:21

user438383 · Accepted Answer · 2022-08-30T09:38:12.333

76

You need to include stat='identity', which is basically telling ggplot2 you will provide the y-values for the barplot, rather than counting the aggregate number of rows for each x value, which is the default stat=count

ggplot(dataset2, aes(x=Region, y= male)) +
     geom_bar(stat='identity')

edited Aug 30 '22 at 09:38

answered Apr 06 '20 at 20:09

user438383

5,716
8
28
43

Error: stat_count() can only have an x or y aesthetic

1 Answers1