This documentation is archived and is not being maintained.

Chart.Export Method

Office 2007
Exports the chart in a graphic format.

Syntax

expression.Export(Filename, FilterName, Interactive)

expression   A variable that represents a Chart object.

Parameters

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
Boolean

Example

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"



Show: