Hi all
I have a pivot chart, and I want the title to change dependant on what is chosen on the actual pivot table.
Ie. I have a contractor field in the pivot and I want to be able to use this in the title of the chart and for it to auto change depending on what the user selects, how do I do this?
Thanks
Carl.
I have a pivot chart, and I want the title to change dependant on what is chosen on the actual pivot table.
Ie. I have a contractor field in the pivot and I want to be able to use this in the title of the chart and for it to auto change depending on what the user selects, how do I do this?
Thanks
Carl.