How can I automatically update a Pivot Chart to a User Defined graph via a Private Sub?

[jnathan]

I want to update a Pivot Chart to a User Defined format that I have saved.

I know that this can be done through a simple line of code using a Private Sub (I used to know how to do this) however I'm just struggling a bit with geeting this to work.

On the worksheet where the Pivot Table is located, I have set the Private Sub to 'Worksheet' 'PivotTableUpdate' but just need the line of code.

Any help would be really appreciated!

Justin