Using Export Charts
- Activate the worksheet than contains the charts to export, and then select
a chart. Or, activate a Chart sheet to export the chart stored there.
- Select Export Charts from the Chart Tools -Design - Export
Charts menu.
- If the active sheet is a worksheet, the Export Charts dialog box lists the
embedded charts on the active sheet. If a Chart sheet is active, the dialog
box lists all Chart sheets.
- Select the charts that you want to export. To select multiple charts,
press Ctrl while you click items in the list.
- To identify a particular chart in the list, select the chart name and
click Scroll to. This will scroll the worksheet such that the selected
chart is displayed in the upper left corner of the window. If you're working
with Chart sheets, the button will display Go to, and clicking it will
activate the selected Chart sheet.
- The file name for each chart is derived from the name of the Chart object
(or the Chart sheet). To rename a chart or Chart sheet, select the chart name
and click Rename. You will then be prompted for a new name for the
Chart object (or Chart sheet). This option is available only when a single
chart is selected in the list.
- Select the Export format for the exported charts
- If you would like a warning if the chart file already exists, select
Warn if file exists.
- The dialog box displays the directory name in which the files will be
saved. Use Change directory to change this directory.
- Click OK to begin exporting the files.
More