(SOLVED) Pivot Table Chart - How to Display the item you are filtered on???

Hi All,

I wonder if anyone can help me.

I have created a chart from a pivot table which is great as the chart will change to whatever I am filtered on, in my case sites spend month on month.

the filter is called Site Name and when I click the drop down I can select site to show but I want to show the name of the site I am filtered on - is this possible?

thanks in advance.
Dan