It lloks like you have qualified these two tables, which means pID field in Typs (Typs.pID) and Locations (Locations.pID) are not associated.
If that is the case, change your load script:
Now use Locations.Location as the dimension in your chart.
Hope that helps
Unfortunately counting won't work correct again.
I need to count the relationships between locations and typs. Your proposal will count (and display) the locations only once for their appearance in Locations. So for each Location it will be 1/n (if n is the total number of rows in Locations).
What I need is to count the appearances of a single Location (this is why I count pID) in Typs and use the name of given in Locations (mapped by pID).
Each counting in table Locations will lead to faulty values.