Excel Help with charts using filters

Hi

I have around 400 rows that I have filtered by location (around 100) so I need a 100 graphs, one for each location. However, I used a filter to change the graph which works except for the title which is the location and it does not seem to change at all although i gave it a cell reference (tried absolute and relative). Is there anyway that the chart title can change everytime i apply a different filter? If there is a way please let me know?

Also, I wanted to add in another column (which contains a percent of the value) into my chart so it displays the value and the percent as well, so I created another series to be added into the graph and then showed no line and no box so it just displays the percent. However, by doing this, it takes away the previous Chart title that I had. Is there a way of fixing this as well?

Thanks for any help that u can give me