Creating a stacked or multi-variable bar graph.

[spatel22]

So, I am having a problem with creating a bar graph that I can plot both of my variables of LifeEB17 which is life expectancy and Basic sanitation on the x-axis and present values on the y-axis. They are both percentage numbers. Please help!

data = HealthNutri
view (HealthNutri)

#Packages
library(ggplot2)
library(tidyr)
library(dplyr)

#Comparison of life expectancy and percentage of people using basic sanitation
HealthNutri <- HealthNutri[c(54, 83, 112, 130, 132, 137, 139, 140, 142, 148, 158, 160, 167, 191, 215, 223, 231, 232),]
HealthNutri <- data.frame(CountryName = c("Australia", "Channel Islands", "France", "Hong Kong SAR", "Iceland", "Ireland", "Israel", "Italy", "Japan", "North Korea", "Liechtenstein", "Luxembourg", "Malta", "Norway", "Singapore", "Spain", "Sweden","Switzerland"), LifeEB17=c(82.5, 83, 82.58, 84.68, 82.66, 82.16, 82.55, 82.94, 84.10, 82.63, 83.75, 82.10, 82.35, 82.61, 83.10, 83.28, 82.41, 83.55), BasicSanitation17 = c(100, 98.5, 98.65, 96.44, 98.78, 91.25, 100, 98.77, 99.89, 100, 99.95, 97.60, 99.96, 98.05, 100, 99.90, 99.29, 99.89))`

[jrkrideau]

Your example data.frame has 19 elements in *BasicSanitation17 * and '8 in the other 2 columns.

It is not clear what your first statement

HealthNutri <- HealthNutri[c(54, 83, 112, 130, 132, 137, 139, 140, 142, 148, 158, 160, 167, 191, 215, 223, 231, 232),]

is intended to do. Are you trying to subset data.frame below it?

[spatel22]

@spatel22

So, I am having a problem with creating a bar graph that I can plot both of my variables of LifeEB17 which is life expectancy and Basic sanitation on the x-axis and present values on the y-axis. They are both percentage numbers. Please help!

data = HealthNutri
view (HealthNutri)

#Packages
library(ggplot2)
library(tidyr)
library(dplyr)

#Comparison of life expectancy and percentage of people using basic sanitation
HealthNutri <- HealthNutri[c(54, 83, 112, 130, 132, 137, 139, 140, 142, 148, 158, 160, 167, 191, 215, 223, 231, 232),]
HealthNutri <- data.frame(CountryName = c("Australia", "Channel Islands", "France", "Hong Kong SAR", "Iceland", "Ireland", "Israel", "Italy", "Japan", "North Korea", "Liechtenstein", "Luxembourg", "Malta", "Norway", "Singapore", "Spain", "Sweden","Switzerland"), LifeEB17=c(82.5, 83, 82.58, 84.68, 82.66, 82.16, 82.55, 82.94, 84.10, 82.63, 83.75, 82.10, 82.35, 82.61, 83.10, 83.28, 82.41, 83.55), BasicSanitation17 = c(100, 98.5, 98.65, 96.44, 98.78, 91.25, 100, 98.77, 99.89, 100, 99.95, 97.60, 99.96, 98.05, 100, 99.90, 99.29, 99.89))`

Each of my variables (BasicSanitation17 and LifeEB17 have 18 values attached to it). My CountryName variable is just the name of the countries corresponding to those 18 values of the variables mentioned above. What I am looking to do is graph values on the Y axis, but plot the LifeEB17 and BasicSanitation17 on the x-axis.

[jrkrideau]

I still am not understanding what you want when I look at your code.

For the data.frame HealthNutri that you have supplied this will give you a barplot

ggplot(HealthNutri, aes(CountryName, LifeEB17)) +
    geom_bar(stat = "identity")

If you wish to have both LifeEB17 and BasicSanitation17 on the same graph in ggplot2 then you will need to change the data. frame from wide to long format .

I think we need to see some sample data in a usable format. Please have a look at

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…