Skip to main content

Chart.Export method

Exports the chart in a graphic format.


expression.Export (FileNameFilterNameInteractive)

expression A variable that represents a Chart object.


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



This example exports chart one as a GIF file.

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>