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.