How do you  refresh pivot chart automatically?
 1 Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. 2 Click Analyze > Options. 3 In the PivotTable Options dialog box, on the Data tab, check the Refresh data when opening the file box. 