Chart Methods (Excel)
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Methods
Name |
Description |
---|---|
Makes the current chart the active chart. |
|
Applies a standard or custom chart type to a chart. |
|
Applies data labels to all the series in a chart. |
|
Applies the layouts shown in the ribbon. |
|
Returns an object that represents either a single axis or a collection of the axes on the chart. |
|
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. |
|
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. |
|
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. |
|
Checks the spelling of an object. |
|
Clears all colors on the specified chart that do not follow the color style applied to the chart. |
|
Clears the chart elements formatting to automatic. |
|
Copies the sheet to another location in the workbook. |
|
Copies the selected object to the Clipboard as a picture. |
|
Deletes the object. |
|
Converts a Microsoft Excel name to an object or a value. |
|
Exports the chart in a graphic format. |
|
Exports to a file of the specified format. |
|
Enables retrieving the filtered out series specified by the Index argument. |
|
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. |
|
Moves the chart to a new location. |
|
Moves the chart to another location in the workbook. |
|
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. |
|
Pastes chart data from the Clipboard into the specified chart. |
|
Prints the object. |
|
Shows a preview of the object as it would look when printed. |
|
Protects a chart so that it cannot be modified. |
|
Causes the specified chart to be redrawn immediately. |
|
Saves changes to the chart or worksheet in a different file. |
|
Saves a custom chart template to the list of available chart templates. |
|
Selects the object. |
|
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. |
|
Sets the background graphic for a chart. |
|
Specifies the name of the chart template that Microsoft Excel uses when creating new charts. |
|
Sets chart elements on a chart. Read/write MsoChartElementType. |
|
Sets the source data range for the chart. |
|
Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected. |