Refreshing Your Chart Data

The Refresh Data command 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.

However, you can archive your chart data, and save it as often as needed. See Changing Refresh Properties for information on how to archive the chart while refreshing the data (or scheduling the archive operation).

You can specifically exclude one or more boxes from the refresh process using the Lock on Refresh option discussed in Excluding Box Contents from Data Refresh. You can also change Refresh settings. For details, see Changing Refresh Properties.

To refresh your chart data from the data source:               

1        With your chart displayed, click the Data tab and select Refresh Data from the Import section.

When the refresh process is complete, you have the option of viewing a log of all changes made.

2        Click Yes if you want to view the log; otherwise click No.