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.