Excel 2010 Pivot charts & displaying filter choice

Hi

I create charts every month, and create a pivot of data and a chart based on the pivot table.

The user can select which manufacturing group they want to look at and the chart refreshes with only that area's data.

But the area chosen's name/title isn't reflected in the graph, so I can't easily cut and paste the chart into reports unless I manually refer them the group they are looking at.

Is it possible please?

Here's an example:

22-10-2014 10-15-59.jpg

Thanks so much I'm really looking forward to hearing from you
Clair