I would like to draw more than one line on the same worksheet as below.
I have a data set which will contain multiple locations. So in the above graph as an example,
Blue = New York
Yellow = New Jersey
I have a list of states and I have to draw one line per state selected. So, if I select 5 states in my filter, then 5 different lines should pop up in the same area.
How do i get this ? Can someone please help?
I was able to figure it out.
Had to drag the lines into the DETAIL section of the marks card and that was all I needed.