AnsweredAssumed Answered

Multi Line - Line Chart Creation

Question asked by amcbaldwin on Oct 30, 2018
Latest reply on Oct 30, 2018 by amcbaldwin

I need to make a chart that overlays multiple lines on a line chart.  Basically, I can do this now but only for each item individually. 

 

The way I have it set up now is to chart an average score Y axis by week X axis. but this just shows me for the whole group. Ideally, I would like to have one line represent the entire group while having each individual item break out into their own line.  Example Below

 

Group                   (week 1 - Average Score 89.1) (Week 2 - Average Score 92.6) (Week 3 - Average Score 86.4)...

Neighborhood 1  (week 1 - Average Score 83.1) (Week 2 - Average Score 85.9) (Week 3 Average Score - 82.3)...

Neighborhood 2 (week1 - Average Score 90.8) (Week 2 - Average Score 94.2) (Week 3 Average Score - 89.9)...

...

...

...

 

I hope this makes this is clear enough for a response but I am totally stuck as I am able to make pretty basic charts with all this data but am having trouble when it comes to parsing out the data.

 

Thanks in advance,

 

Andrew

Outcomes