Load data
library(tidyverse)
library(readxl)
County_Counts <- read_excel("CountyCounts.xlsx")
Create subset with counties of interest
County_Comparison <- County_Counts%>%
filter(`CoC Number`=="WA-500"| `CoC Number`== "CA-501"| `CoC Number`== "CA-600"| `CoC Number` == "DC-500"| `CoC Number`== "NY-600")
County_Comparison$`Overall Homeless, 2018` <-as.numeric(County_Comparison$`Overall Homeless, 2018`)
Line graph
ggplot(data = County_Comparison, aes(x = `Year`, y = `Overall Homeless, 2018`, group = `CoC Name`, color = `CoC Name`))+
geom_line()+
geom_point()+
scale_y_log10()+
ylab("Homeless Population")
