Using Text Tools

# Export Charts Tips

- If a worksheet is active when you invoke the Export Charts utility, the dialog box displays a list of all chart objects on the active worksheet. If a chart sheet is active when you invoke the Export Charts utility, the dialog box displays a list of all chart sheets in the active workbook.
- The Export Charts utility uses the graphic export filters supplied with Excel (or Microsoft Office). If you are unable to export to a particular file format, re-run the Setup program for Excel (or Microsoft Office).
- The GIF and PNG file formats usually produce the best quality output.
- The dimensions of the exported file will match the chart dimensions.
- To help identify a particular chart, select it in the list and click Scroll to (or Go to, if a Chart sheet is active).
- When exporting a chart on a chart sheet (or on multiple chart sheets), you can adjust the size of the chart(s) by resizing the workbook window. Make sure the workbook's window isn't maximized, then adjust the window size to match the desired chart size.
- The file names are based on the Chart object names (or Chart sheet name) -- with an underscore character substituted for each space.
- Use the Rename button to change the name of a Chart object or a Chart sheet. This will also change the name of the exported file name. The Rename button is available only when a single chart in the list is selected.
- You can also change the name of an embedded Chart object manually: Select the chart and use the Chart Name box in the Chart Tools - Layout - Properties group.