This documentation is archived and is not being maintained.

Chart.Export Method

Office 2007
Exports the chart in a graphic format.


expression.Export(Filename, FilterName, Interactive)

expression   A variable that represents a Chart object.


NameRequired/OptionalData TypeDescription
FilenameRequiredStringThe name of the exported file.
FilterNameOptionalVariantThe language-independent name of the graphic filter as it appears in the registry.
InteractiveOptionalVariantTrue 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.

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