You must refresh a chart to create an archive. To automatically refresh data on a periodic basis, see Refreshing Your Chart Data.
To set archiving options as part of the refresh properties:
1 In the Refresh Properties dialog box, click the Archive tab and select the archiving options you want to use.
· Archive chart before refresh: Saves a copy of the chart before the refresh process. By default, this option saves the chart in the My Charts\Archive folder.
· Archive Folder: The default location for the Archive folder is under My Charts. You can change it by clicking the Browse button and selecting a different location.
· Archive File Management: Select how often you want to create a new archive file:
· Every refresh: This saves a copy of the chart each time you refresh the data, either manually or automatically.
· Every day: This saves a copy of the chart on a daily basis. Only one archive will be created in a given day regardless of the number of times the chart is refreshed.
· Every week: This saves a copy of the chart on a weekly basis. Only one archive will be created in a given week regardless of the number of times the chart is refreshed.
2 Click OK to save your archiving options and other changes you have made in the Refresh Properties dialog box.