ggplot - geom_line not plotting line

Question

with a dataframe df like below, Im trying to create a line chart for one of the parameters - Income - in the real data there are other parameters.

text <- "
Parameter,Company, Qtr, Value
Income, Comp1, Q1FY18, 100
Income, Comp1, Q2FY18, 110
Income, Comp1, Q3FY18, 130
Income, Comp2, Q1FY18, 60
Income, Comp2, Q2FY18, 70
Income, Comp2, Q3FY18, 90
"
df <- read.table(textConnection(text), sep=",", header = T,
                 stringsAsFactors = F)

I created a function such that I can re-use this - the function takes a dataframe and set of metrics and plot them

plotMetricsLine <- function(df, metrics) {
  df <- df %>%
    filter(Parameter %in% metrics)
  p <- ggplot(data=df, aes(x=Qtr, y=Value,color = Company)) +
    geom_line(size=1)
  return(p)
}

When I'm using that function by calling plotMetricsLine(df, "Income") - it is giving an empty plot as in the picture below. What is going on wrong here ?

In your own function, add group = Company in aes(). That will work for you. — jazzurro
– jazzurro, Commented Feb 8, 2018 at 2:25
I think this question is almost same to yours. If you want, have a look. — jazzurro
– jazzurro, Commented Feb 8, 2018 at 2:32
Note that this happens because your x-variable is a factor, and ggplot assumes it should set the group accordingly. — Axeman
– Axeman, Commented Feb 8, 2018 at 8:56
@Axeman Thanks for the clarification. I notice that for geom_bar the plot is fine without setting up group - what is the difference for that ? — user3206440
– user3206440, Commented Feb 8, 2018 at 13:16

Axeman · Accepted Answer · 2018-02-08 08:57:21Z

1

You also need to set group in aes, not just color. This function works:

plotMetricsLine <- function(df, metrics) {
  df <- df%>%filter(Parameter %in% metrics)
  p <-ggplot(data=df, aes(x=Qtr, y=Value,group = as.factor(Company),colour=Company)) +
    geom_line(size=1)
  return(p)
}
plotMetricsLine(df, "Income")

note the colour so it has different color depending on the factor

edited Feb 8, 2018 at 8:57

Axeman

35.7k8 gold badges87 silver badges101 bronze badges

answered Feb 8, 2018 at 2:27

Alejandro Andrade

2,21623 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

ggplot - geom_line not plotting line

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related