Creating line graph in ggplot2

Question

So I have the following data:

df <- structure(list(m_y = structure(c(1L, 13L, 10L, 11L, 12L, 2L, 
14L, 3L, 15L, 4L, 16L, 5L, 17L, 6L, 18L, 7L, 8L, 9L, 1L, 13L, 
10L, 11L, 12L, 2L, 14L, 3L, 15L, 4L, 16L, 5L, 17L, 6L, 18L, 7L, 
8L, 9L), .Label = c("1-2018", "2-2018", "3-2018", "4-2018", "5-2018", 
"6-2018", "7-2018", "8-2018", "9-2018", "10-2018", "11-2018", 
"12-2018", "1-2019", "2-2019", "3-2019", "4-2019", "5-2019", 
"6-2019"), class = "factor"), count = c(29L, 32L, 32L, 22L, 26L, 
34L, 29L, 46L, 31L, 40L, 26L, 35L, 28L, 47L, 37L, 44L, 36L, 21L, 
80L, 84L, 59L, 51L, 48L, 60L, 63L, 67L, 63L, 52L, 58L, 65L, 50L, 
67L, 61L, 67L, 70L, 65L), Reportable = c("Non", 
"Non", "Non", "Non", 
"Non", "Non", "Non", 
"Non", "Non", "Non", 
"Non", "Non", "Non", 
"Non", "Non", "Non", 
"Non", "Non", "Report", 
"Report", "Report", "Report", 
"Report", "Report", "Report", 
"Report", "Report", "Report", 
"Report", "Report", "Report", 
"Report", "Report", "Report", 
"Report", "Report")), row.names = c(NA, 
-36L), groups = structure(list(m_y = structure(1:18, .Label = c("1-2018", 
"2-2018", "3-2018", "4-2018", "5-2018", "6-2018", "7-2018", "8-2018", 
"9-2018", "10-2018", "11-2018", "12-2018", "1-2019", "2-2019", 
"3-2019", "4-2019", "5-2019", "6-2019"), class = "factor"), .rows = structure(list(
    c(1L, 19L), c(6L, 24L), c(8L, 26L), c(10L, 28L), c(12L, 30L
    ), c(14L, 32L), c(16L, 34L), c(17L, 35L), c(18L, 36L), c(3L, 
    21L), c(4L, 22L), c(5L, 23L), c(2L, 20L), c(7L, 25L), c(9L, 
    27L), c(11L, 29L), c(13L, 31L), c(15L, 33L)), ptype = integer(0), class = c("vctrs_list_of", 
"vctrs_vctr", "list"))), row.names = c(NA, 18L), class = c("tbl_df", 
"tbl", "data.frame"), .drop = TRUE), class = c("grouped_df", 
"tbl_df", "tbl", "data.frame"))

and I thought making this a line graph with two lines (indicated by Reportable) would be as simple as the following but this doesn't seem to be the case...

ggplot(df, aes(y=count, x=as.factor(m_y), color=Reportable)) +
  geom_line()

Side point: while using factor on strings in order to arrange your x-axis correctly (vice alphabetically) is one way to ensure the axis is correct, if you ever have gaps in your m_y variable, this plot will not show it. It is often better to keep the original variable as class Date (numeric-like), and use a labeller function for how to show it on the axis. — r2evans
– r2evans, Commented Aug 10, 2020 at 20:36

Duck · Accepted Answer · 2020-08-10 20:34:20Z

1

Try this:

ggplot(df, aes(y=count, x=factor(m_y), color=Reportable,group=Reportable)) +
  geom_line()

Output:

answered Aug 10, 2020 at 20:34

Duck

39.6k14 gold badges47 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

John Thomas Over a year ago

This works however now my additional line of scale_fill_manual(values = c("darkorange", "cornflowerblue") ) , doesn't..

Duck Over a year ago

@JohnThomas Try scale_color_manual() instead! Let me know if that works!

John Thomas Over a year ago

Thanks a duck duck!

Julian Neuer · Accepted Answer · 2020-08-10 20:34:33Z

0

ggplot(df, aes(y=count, x=as.factor(m_y), group=Reportable, color=Reportable)) +
  geom_line()

BUT there is only one observation for Non-Reportable, so no line will appear for that.

You can use points AND lines:

ggplot(df, aes(y=count, x=as.factor(m_y), group=Reportable, color=Reportable)) +
  geom_line() +
  geom_point()

answered Aug 10, 2020 at 20:34

Julian Neuer

3161 silver badge8 bronze badges

Collectives™ on Stack Overflow

Creating line graph in ggplot2

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related