Pivot Chart Title variable

[Guest]

I was trying to create a Pivot Chart where the Title varies dependent on the
selection made from the dropdown box. I dont know the commands to reference
the current Pivotchart's variables therefore i cant pull the information i
need. Anyhelp would be appreciated! If this isnt the right area to post,
can someone lead me in the right direction.

Thanks
Tim

 

[Debra Dalgleish]

You can link the chart title to a cell, in which you calculate the title
text. There's a sample here:

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'Employee Time Tracking'