I have a graph which runs from a pivot table and gives various different ouputs, however to make it really user friendly, I would like the graph title to update automatically when I change the pivot to reflect what the graph is actually showing. Does anyone have any ideas how I could achieve this

Many Thanks