_Chart Methods

The _Chart type exposes the following members.

  Name Description
Public method _ApplyDataLabels Reserved for internal use.
Public method _Dummy23 Reserved for internal use.
Public method _Evaluate Reserved for internal use.
Public method _PrintOut Reserved for internal use.
Public method _Protect Reserved for internal use.
Public method _SaveAs Reserved for internal use.
Public method Activate Makes the current chart the active chart.
Public method ApplyChartTemplate Applies a standard or custom chart type to a chart.
Public method ApplyCustomType Applies a standard or custom chart type to a chart.
Public method ApplyDataLabels Applies data labels to a point, a series, or all the series in a chart.
Public method ApplyLayout Applies the layouts shown in the ribbon.
Public method Arcs Reserved for internal use.
Public method AreaGroups On a 2-D chart, returns an object that represents either a single area chart group (a ChartGroup object) or a collection of the area chart groups (a ChartGroups collection).
Public method AutoFormat Reserved for internal use.
Public method Axes Returns an object that represents either a single axis or a collection of the axes on the chart.
Public method BarGroups On a 2-D chart, returns an object that represents either a single bar chart group (a ChartGroup object) or a collection of the bar chart groups (a ChartGroups collection).
Public method Buttons Reserved for internal use.
Public method 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.
Public method 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.
Public method 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 non-interactive, and it changes only the specified properties.
Public method CheckBoxes Reserved for internal use.
Public method CheckSpelling Checks the spelling of an object and displays the Spelling dialog box
Public method ClearToMatchStyle Clears the chart elements formatting to automatic.
Public method ColumnGroups On a 2-D chart, returns an object that represents either a single column chart group (a ChartGroup object) or a collection of the column chart groups (a ChartGroups collection).
Public method Copy Copies the sheet to another location in the workbook.
Public method CopyChartBuild Reserved for internal use.
Public method CopyPicture Copies the selected object to the Clipboard as a picture.
Public method CreatePublisher Reserved for internal use.This member is for Macintosh only and should not be used.
Public method Delete Deletes the object.
Public method Deselect Cancels the selection for the specified chart.
Public method DoughnutGroups On a 2-D chart, returns an object that represents either a single doughnut chart group (a ChartGroup object) or a collection of the doughnut chart groups (a ChartGroups collection).
Public method DrawingObjects Reserved for internal use.
Public method Drawings Reserved for internal use.
Public method DropDowns For callouts with an explicitly set drop value, this property returns the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. Read-only Single.
Public method Evaluate Converts a Microsoft Excel name to an object or a value.
Public method Export Exports the chart in a graphic format.
Public method ExportAsFixedFormat Exports to a file of the specified format.
Public method 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.
Public method GroupBoxes Reserved for internal use.
Public method GroupObjects Reserved for internal use.
Public method Labels Reserved for internal use.
Public method LineGroups On a 2-D chart, returns an object that represents either a single line chart group (a ChartGroup object) or a collection of the line chart groups (a ChartGroups collection).
Public method Lines Reserved for internal use. f
Public method ListBoxes Returns or sets the text entries in the specified list box or a combo box, as an array of strings, or returns or sets a single text entry. An error occurs if there are no entries in the list.
Public method Location Moves the chart to a new location.
Public method Move Moves the sheet to another location in the workbook.
Public method 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.
Public method OptionButtons Reserved for internal use.
Public method Ovals Reserved for internal use.
Public method Paste Pastes chart data from the Clipboard into the specified chart.
Public method Pictures Reserved for internal use.
Public method PieGroups On a 2-D chart, returns an object that represents either a single pie chart group (a ChartGroup object) or a collection of the pie chart groups (a ChartGroups collection).
Public method PrintOut Prints the object.
Public method PrintOutEx Reserved for internal use.
Public method PrintPreview Shows a preview of the object as it would look when printed.
Public method Protect Protects a chart so that it cannot be modified.
Public method RadarGroups On a 2-D chart, returns an object that represents either a single radar chart group (a ChartGroup object) or a collection of the radar chart groups (a ChartGroups collection).
Public method Rectangles Reserved for internal use.
Public method Refresh Updates the cache of the Chart or PivotTable object.
Public method SaveAs Saves changes to the chart or worksheet in a different file.
Public method SaveChartTemplate Saves a custom chart template to the list of available chart templates.
Public method ScrollBars Reserved for internal use.
Public method Select Selects the object.
Public method 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.
Public method SetBackgroundPicture Sets the background graphic for a worksheet or chart.
Public method SetDefaultChart Specifies the name of the chart template that Microsoft Excel uses when creating new charts.
Public method SetElement Sets chart elements on a chart. Read/write.
Public method SetSourceData Sets the source data range for the chart.
Public method Spinners Reserved for internal use.
Public method TextBoxes Reserved for internal use.
Public method Unprotect Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
Public method XYGroups On a 2-D chart, returns an object that represents either a single scatter chart group (a ChartGroup object) or a collection of the scatter chart groups (a ChartGroups collection).
Top
Show: