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

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

Under Pivot Tables, look for 'Employee Time Tracking'

Tim wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html