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.

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"



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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.