Refresh updates the chart data from the source. In the refresh process, your source data overwrites the data in your chart. Other than formatting, refresh does not preserve any changes made directly to a chart.
Note: You can specifically exclude one or more boxes from the refresh process using the Lock on Refresh option discussed below in Excluding Box Contents.
You can change Refresh settings. For details, see Changing Refresh Properties.
To refresh your chart data from the data source:
1 With your chart displayed, select Refresh Data from the Data menu.
2
Because data refresh may be time consuming
(especially for large charts), you will be prompted to continue. Click Yes.
When the refresh process is complete, you have the option of viewing a log of
all changes made
3 Click Yes if you want to view the log; otherwise click No.