Using Export Charts

  1. 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.
  2. Select Export Charts from the Chart Tools -Design - Export Charts menu.
  3. 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.
  4. Select the charts that you want to export. To select multiple charts, press Ctrl while you click items in the list.
  5. 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.
  6. 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.
  7. Select the Export format for the exported charts
  8. If you would like a warning if the chart file already exists, select Warn if file exists.
  9. The dialog box displays the directory name in which the files will be saved. Use Change directory to change this directory.
  10. Click OK to begin exporting the files.

More