Chart.Export Method (Excel)
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"