Creating a line chart with 2 lines based on locations

[Anonymous]

This seems pretty simple but I can't seem to find a solution.

I will give an easy to use example to make my question easier to understand. I have 100 locations in one column, and another column with profit per month for each location. I want to separate the 100 locations into 50 and 50 (for east and west) and have two lines in my chart that represent the two groups to show how east and west rank against one another. Thanks.

[Fowmy · Accepted solution]

@Anonymous 

Create a new column in the table that groups the locations into East and West based on your logic then add this new column as a Legend in the line chart.