Auto update Pivot Chart

Hi,

Apologies if this has been answered but my searches don't seem to resolve my question.

I have created a Dashboard that I want to use as a template.

Daily transaction data will be appended to the data tab and I want to make sure that the pivot table and chart update automatically. Is there a way to do this?

See attached file.

Thanks

Create a named range by using the below formula then pass the name as the data source of all the pivots, then create the charts from the updated piovt tables. use the below code in any of the event of your choice to refresh the all the pivot Tables.

=OFFSET('Sheetname'!$A$1,0,0,COUNTA('Sheetname'!$A:$A),COUNTA('Sheetname'!$A$1:$IV$1))


Dim ws As Worksheet
Dim pivot As PivotTable
'Dim z As PivotCache
For Each ws In oWB_Data_File.Worksheets
If ws.PivotTables.Count > 0 Then
For Each pivot In ws.PivotTables
pivot.RefreshTable
Next pivot
End If
Next