How can you refresh a Pivot Chart ?

**rushdenx1** · 04-05-2012, 02:53 PM

I have a small Pivot Table which has an associated Pivot Chart. I have just added some data to the Pivot Table and refresh it. How can I get the Pivot Chart to update automatically to include the new data I've added ? Kevin.

**JieJenn** · 04-05-2012, 02:57 PM

In worksheet module, insert the code like you see below. You might need to change the name of the pivot table that you're using

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("XXXXX").PivotTables("Insert Pivot Table Name Here").PivotCache.Refresh
End Sub

**rushdenx1** · 04-05-2012, 06:24 PM

Thanks. The code does update the Pivot Table, but I have a Pivot Chart (Pie Chart) which I also want to update automatically when the Pivot Table has additional data added. How can you update the Pie Chart without having to create a new one. Thanks Kevin.