Picture of Chart I am aiming to create -- please help!!

[brandnew22]

I have drawn the idea for the type of chart I want to create. The aim is to show where competitors price in each market. Instead of having all of our businesses and all of our competitors plotted all over a chart, I am trying to make a line chart where the X axis is a location and the Y axis is price, so for each location (C), there are points that correspond to our prices for the product vs. our competitors prices. is there a way to categorize sub categories in a pivot table so that multiple sub categories can be rolled up into 1 "series" for a chart? For example, if my company has businesses at one location, instead of having the 10 different names as points on the chart/plot, could I have 10 different points all with one color/as a part of 1 series? Please see picture for my aim.

Thanks.