Chart.Export (Excel)

Exports the chart in a graphic format.

Export (Filename, FilterName, Interactive)

Worksheets("Sheet1").ChartObjects(1) _ 
.Chart. Export _ 
 FileName:="current_sales.gif", FilterName:="GIF"

Arguments

The following argument is required

Filename (String) - The name of the exported file.

Optional arguments

The following arguments are optional

FilterName (String) - The language-independent name of the graphic filter as it appears in the registry.

Interactive (Boolean) - 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.