Chart Object Methods

Name Returns Parameters Description

Activate Variant Makes the embedded chart the active chart

BringToFront

Variant

Brings the embedded chart to the front of

all the other objects on the sheet. Changes

the ZOrder

Copy

Variant

Copies the embedded chart into the

clipboard

Name

Returns

Parameters

Description

CopyPicture

XlPicture

Appearance,

Format As

XlCopyPicture

Format

Copies the Chart object into the clipboard as a picture. The Appearance parameter can be used to specify whether the picture is copied as it looks on the screen or when printed. The Format parameter can specify the type of picture that will be put into the clipboard. The Size parameter is used when dealing with chart sheets to describe the size of the picture

Cut

Variant

Cuts an embedded chart into the clipboard

Delete

Variant

Deletes the embedded chart from the sheet

Duplicate

Duplicates the embedded chart and places the duplicate in the same parent sheet

Select

Variant

[Replace]

Sets focus to the embedded chart

SendToBack

Variant

Sends the embedded object to the back of the other objects on the sheet

0 0

Post a comment