Pivot Change event

[Reney Langlois]

Is there a way I can capture a pivot table selection
change event in code? I have a chart sitting on a
spreadsheet next to a pivot table and I'd like to update
the chart title automatically when someone chooses a
different category in one of the drop down lists in the
pivot table.

 

[Debra Dalgleish]

In a cell on the worksheet, enter a formula to create the title you
want. For example: ="Sales for " &B1
where cell B1 is the category in the pivot table.

Then, select the Title in the Pivot Chart
Type an equal sign, and click on the cell where you entered the formula
The formula bar will show something similar to: =Pivot!$E$1

When you change the category in cell B1, the chart title will change.