Exports the chart in a graphic format.
Syntax
expression.Export (FileName, FilterName, Interactive)
expression A variable that represents a Chart object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| FileName | Required | String | The name of the exported file. |
| FilterName | Optional | Variant | The language-independent name of the graphic filter as it appears in the registry. |
| Interactive | Optional | Variant | True to display the dialog box that contains the filter-specific options. If this argument is False, Microsoft Excel uses the default values for the filter. The default value is False. |
Return value
Boolean
Example
This example exports chart one as a GIF file.
Worksheets("Sheet1").ChartObjects(1).Chart.Export Filename:="current_sales.gif", FilterName:="GIF"