Pivot Chart Title variable

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

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'

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