how to see groups in a filter against either on a line chart

[tjayne13]

Hi, so I have data with columns date, location, count, and I want to show over time, the count for each of the locations against eachother. When I put location into the filter and choose some, it averages them together. Is there any way to see the different variables in the filter seperately on the same line graph?

Thanks in advance!

[chrisu · Accepted solution]

If I am understanding correctly, I think what you need to do is add Location to the Legend area and Count to the Values area of the line chart.  That should give you a line for each location.  

[tjayne13]

Thanks! Thats exactly what I needed.