Pivot Chart Title variable

#1 05-24-2005, 02:06 PM

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

#2 05-24-2005, 05:06 PM

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)