|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
Re: Pivot Chart Title variable
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 |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|