Chart Methods (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

Activate

Makes the current chart the active chart.

ApplyChartTemplate

Applies a standard or custom chart type to a chart.

ApplyDataLabels

Applies data labels to all the series in a chart.

ApplyLayout

Applies the layouts shown in the ribbon.

Axes

Returns an object that represents either a single axis or a collection of the axes on the chart.

ChartGroups

Returns an object that represents either a single chart group (a ChartGroup object) or a collection of all the chart groups in the chart (a ChartGroups object). The returned collection includes every type of group.

ChartObjects

Returns an object that represents either a single embedded chart (a ChartObject object) or a collection of all the embedded charts (a ChartObjects object) on the sheet.

ChartWizard

Modifies the properties of the given chart. You can use this method to quickly format a chart without setting all the individual properties. This method is noninteractive, and it changes only the specified properties.

CheckSpelling

Checks the spelling of an object.

ClearToMatchColorStyle

Clears all colors on the specified chart that do not follow the color style applied to the chart.

ClearToMatchStyle

Clears the chart elements formatting to automatic.

Copy

Copies the sheet to another location in the workbook.

CopyPicture

Copies the selected object to the Clipboard as a picture.

Delete

Deletes the object.

Evaluate

Converts a Microsoft Excel name to an object or a value.

Export

Exports the chart in a graphic format.

ExportAsFixedFormat

Exports to a file of the specified format.

FullSeriesCollection

Enables retrieving the filtered out series specified by the Index argument.

GetChartElement

Returns information about the chart element at specified X and Y coordinates. This method is unusual in that you specify values for only the first two arguments. Microsoft Excel fills in the other arguments, and your code should examine those values when the method returns.

Location

Moves the chart to a new location.

Move

Moves the chart to another location in the workbook.

OLEObjects

Returns an object that represents either a single OLE object (an OLEObject ) or a collection of all OLE objects (an OLEObjects collection) on the chart or sheet. Read-only.

Paste

Pastes chart data from the Clipboard into the specified chart.

PrintOut

Prints the object.

PrintPreview

Shows a preview of the object as it would look when printed.

Protect

Protects a chart so that it cannot be modified.

Refresh

Causes the specified chart to be redrawn immediately.

SaveAs

Saves changes to the chart or worksheet in a different file.

SaveChartTemplate

Saves a custom chart template to the list of available chart templates.

Select

Selects the object.

SeriesCollection

Returns an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.

SetBackgroundPicture

Sets the background graphic for a chart.

SetDefaultChart

Specifies the name of the chart template that Microsoft Excel uses when creating new charts.

SetElement

Sets chart elements on a chart. Read/write MsoChartElementType.

SetSourceData

Sets the source data range for the chart.

Unprotect

Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.

Show: