Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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"

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.