What do you need explaining?
There are many posts on charts using dynamic named ranges.
The vba code required would greatly depend on your workbook setup. The update event can be located by right clicking the sheet tab with the pivot table on. This will take you to the VBE. Select Workbook in the left hand dropdown. The select the PivotTableUpdate event from the right hand dropdown.
Post an example workbook if you need more help.
Bookmarks