Line chart with data in one column and series in another.

[spcman]

I have a worksheet that contains variable data in one column and the location it came from in another. I want to chart all the data in the one column based on its location. For example if my worksheet looked like this:
Data Location
21 1
342 1
312 2
35 2
94 1
45 3
58 2
ect...
I want to make a line chart with a series for each location. This file will update regularly and I want the graph to do the same.

Thanks for your help.