I am working with Pivot Charts in Excel 2010. When a user changes the selections in the report filter, I want to make changes in the resulting data series format. Two questions:

1- Do I need to force an update before I change the data series format?

2- Is Worksheet_PivotTableAfterValueChange the event I should be using to trigger the code?

New to Pivot Tables and been away from VBA for a couple years, so feel free to assume I don't know anything anymore.